Entries by Oracle ERP Apps Guide

, , , , ,

Query for Customer Receipt Details

SELECT   acra.cash_receipt_id,         DECODE (acra.TYPE,                 ‘cash’, ‘cash receipt receipt’,                 ‘misc’, ‘miscellaneous’,                 acra.TYPE                ) receipt_type,         acra.currency_code, acra.doc_sequence_value receipt_number,         acra.receipt_number reference_number,         TRUNC (acra.receipt_date) receipt_date, hp.party_name received_from,         acra.misc_payment_source, hca.account_number customer_no,         NVL (acra.amount, 0) entered_amount,         NVL (acra.amount, 0) * NVL (acra.exchange_rate, 1) functional_amount,         arm.NAME payment_method, abaa.bank_account_num bank_acc_num,         abb.bank_name, abb.bank_branch_name, acra.comments description    FROM ar_cash_receipts_all acra,         ar_receipt_methods arm,         ap_bank_accounts_all abaa,         ap_bank_branches abb,         […]

/by
, , , ,

Concurrent Request Status in R12

SELECT   fcr.phase_code,         DECODE (fcr.phase_code,’C’, ‘Completed’, ‘P’, ‘Pending’, ‘R’, ‘Running’, ‘I’, ‘Inactive’, fcr.phase_code) phase,         fcr.status_code,         DECODE (fcr.status_code,’A’, ‘Waiting’,                                ‘B’, ‘Resuming’,                                ‘C’, ‘Normal’,                                ‘D’, ‘Cancelled’,                                ‘E’, ‘Error’,                                ‘F’, ‘Scheduled’,                                ‘G’, ‘Warning’,                                ‘H’, ‘On Hold’,                                ‘I’, ‘Normal’,                                ‘M’, ‘No Manager’,                                ‘Q’, ‘Standby’,                                ‘R’, ‘Normal’,                                ‘S’, ‘Suspended’,                                ‘T’, ‘Terminating’,                                ‘U’, ‘Disabled’,                                ‘W’, ‘Paused’,                                ‘X’, ‘Terminated’,                                ‘Z’, ‘Waiting’,                                fcr.status_code) status,         […]

/by
, , , ,

API to Purge an person from Oracle HRMS

DECLARE l_person_org_manager_warning VARCHAR2 (200); BEGIN hr_person_api.delete_person(p_validate => FALSE, p_effective_date => SYSDATE, p_person_id => :person_id, p_perform_predel_validation => FALSE, p_person_org_manager_warning => l_person_org_manager_warning ); COMMIT; END; Before purging the person from Oracle HRMS we need to make sure that the employee and fnd_user link is been deleted and also the person should not have an active payroll. If […]

/by
, , , ,

Query that shows all the repsonsibilities and what functions are attached to these responsibilities

SELECT DISTINCT faa.application_name application, rtl.responsibility_name,ffl.user_function_name, ff.function_name, ffl.description,ff.TYPEFROM fnd_compiled_menu_functions cmf,fnd_form_functions ff,fnd_form_functions_tl ffl,fnd_responsibility r,fnd_responsibility_vl rtl,apps.fnd_application_all_view faaWHERE cmf.function_id = ff.function_idAND r.menu_id = cmf.menu_idAND rtl.responsibility_id = r.responsibility_idAND cmf.grant_flag = ‘Y’AND ff.function_id = ffl.function_idAND faa.application_id(+) = r.application_idAND r.end_date IS NULLAND rtl.end_date IS NULLORDER BY rtl.responsibility_name;

/by