ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 C6E085D4721D51A9E05362FB09050512 select age_employee_id, age_supervisor_id, age_emp_status, age_billed_date, age_posted_date, aging_amount, aging_report_status_code, dispute_flag, trx_id, person_id, AP_APXCCOUT_XMLP_PKG.cf_aging_sup_nameformula(age_supervisor_id) CF_aging_sup_name, posted_date, billed_amount, AP_APXCCOUT_XMLP_PKG.cf_age_sup_pend_bucklet1formul(:CS_sup_bucket1, :CS_sup_bucket2, :CS_sup_bucket3, :CS_sup_bucket4) CF_age_sup_pend_bucklet1, AP_APXCCOUT_XMLP_PKG.CP_age_sup_name_p CP_age_sup_name, AP_APXCCOUT_XMLP_PKG.CP_sup_pend_bucket1_p CP_sup_pend_bucket1, AP_APXCCOUT_XMLP_PKG.CP_sup_pend_bucket2_p CP_sup_pend_bucket2, AP_APXCCOUT_XMLP_PKG.CP_sup_pend_bucket3_p CP_sup_pend_bucket3, AP_APXCCOUT_XMLP_PKG.CP_sup_pend_bucket4_p CP_sup_pend_bucket4, AP_APXCCOUT_XMLP_PKG.cf_age_amp_nameformula(person_id, 'Active') CF_age_amp_name, AP_APXCCOUT_XMLP_PKG.CP_age_emp_name_p CP_age_emp_name, AP_APXCCOUT_XMLP_PKG.cf_aging_bucketsformula(posted_date, billed_amount) CF_aging_buckets, AP_APXCCOUT_XMLP_PKG.cf_pending_amountsformula(aging_report_status_code, posted_date, billed_amount) CF_pending_amounts, AP_APXCCOUT_XMLP_PKG.CP_appr_pend_bucket1_p CP_appr_pend_bucket1, AP_APXCCOUT_XMLP_PKG.CP_appr_pend_bucket3_p CP_appr_pend_bucket3, AP_APXCCOUT_XMLP_PKG.CP_appr_pend_bucket4_p CP_appr_pend_bucket4, AP_APXCCOUT_XMLP_PKG.CP_appr_pend_bucket2_p CP_appr_pend_bucket2, AP_APXCCOUT_XMLP_PKG.CP_emp_pend_bucket1_p CP_emp_pend_bucket1, AP_APXCCOUT_XMLP_PKG.CP_emp_pend_bucket2_p CP_emp_pend_bucket2, AP_APXCCOUT_XMLP_PKG.CP_emp_pend_bucket3_p CP_emp_pend_bucket3, AP_APXCCOUT_XMLP_PKG.CP_emp_pend_bucket4_p CP_emp_pend_bucket4, AP_APXCCOUT_XMLP_PKG.CP_sys_pend_bucket2_p CP_sys_pend_bucket2, AP_APXCCOUT_XMLP_PKG.CP_sys_pend_bucket3_p CP_sys_pend_bucket3, AP_APXCCOUT_XMLP_PKG.CP_sys_pend_bucket4_p CP_sys_pend_bucket4, AP_APXCCOUT_XMLP_PKG.CP_sys_pend_bucket1_p CP_sys_pend_bucket1, AP_APXCCOUT_XMLP_PKG.CP_mgr_pend_bucket1_p CP_mgr_pend_bucket1, AP_APXCCOUT_XMLP_PKG.CP_mgr_pend_bucket2_p CP_mgr_pend_bucket2, AP_APXCCOUT_XMLP_PKG.CP_mgr_pend_bucket3_p CP_mgr_pend_bucket3, AP_APXCCOUT_XMLP_PKG.CP_mgr_pend_bucket4_p CP_mgr_pend_bucket4, AP_APXCCOUT_XMLP_PKG.CP_bucket1_p CP_bucket1, AP_APXCCOUT_XMLP_PKG.CP_bucket2_p CP_bucket2, AP_APXCCOUT_XMLP_PKG.CP_bucket3_p CP_bucket3, AP_APXCCOUT_XMLP_PKG.CP_bucket4_p CP_bucket4, AP_APXCCOUT_XMLP_PKG.CP_emp_pending_p CP_emp_pending, AP_APXCCOUT_XMLP_PKG.CP_sys_pending_p CP_sys_pending, AP_APXCCOUT_XMLP_PKG.CP_mgr_pending_p CP_mgr_pending, AP_APXCCOUT_XMLP_PKG.CP_appr_pending_p CP_appr_pending from (select distinct emp.person_id age_employee_id, pera.supervisor_id age_supervisor_id, 'Active' age_emp_status, nvl(cct.billed_date,cct.posted_date) age_billed_date, cct.posted_date age_posted_date, cct.billed_amount aging_amount, AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source, erh.workflow_approved_flag,erh.report_header_id) aging_report_status_code, 'N' dispute_flag, cct.trx_id trx_id, cct.posted_date posted_date, cct.billed_amount billed_amount, emp.person_id from ap_credit_card_trxns cct, ap_cards_all ac, ap_card_programs_all cp, ap_expense_report_headers erh, per_all_people_f emp, per_assignments_f pera, per_assignment_status_types peras where cct.card_program_id = :p_card_program_id and cct.validate_code = 'Y' and cct.payment_flag <> 'Y' and nvl(cct.category,'BUSINESS') = 'PERSONAL' and erh.report_header_id = cct.report_header_id and NVL(erh.vouchno, 0) = 0 and AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode( erh.source,erh.workflow_approved_flag,erh.report_header_id) in ('SAVED', 'INPROGRESS', 'EMPAPPR', 'REJECTED', 'RESOLUTN', 'RETURNED', 'PENDMGR', 'MGRAPPR','ERROR','INVOICED','WITHDRAWN') and exists (select 'Y' from ap_expense_report_lines xl where erh.report_header_id = xl.report_header_id) and ac.card_program_id = cct.card_program_id and ac.card_id = cct.card_id and cp.card_program_id = cct.card_program_id and ac.employee_id = emp.person_id and emp.person_id = pera.person_id and pera.primary_flag = 'Y' and pera.assignment_status_type_id = peras.assignment_status_type_id and peras.per_system_status = 'ACTIVE_ASSIGN' and trunc(sysdate) between pera.effective_start_date and pera.effective_end_date &lp_min_amt_where &lp_emp_mgr UNION ALL select distinct emp.person_id age_employee_id, pera.supervisor_id age_supervisor_id, 'Active' age_emp_status, nvl(cct.billed_date,cct.posted_date) age_billed_date, cct.posted_date age_posted_date, cct.billed_amount aging_amount, AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source, erh.workflow_approved_flag,erh.report_header_id) aging_report_status_code, 'N' dispute_flag, cct.trx_id trx_id, cct.posted_date posted_date, cct.billed_amount billed_amount, emp.person_id from ap_credit_card_trxns cct, ap_cards_all ac, ap_card_programs_all cp, ap_expense_report_headers erh, per_all_people_f emp, per_assignments_f pera, per_assignment_status_types peras where cct.card_program_id = :p_card_program_id and cct.validate_code = 'Y' and cct.payment_flag <> 'Y' and nvl(cct.category,'BUSINESS') not in ( 'DISPUTED','PERSONAL', 'DEACTIVATED') and nvl(cct.expensed_amount, 0) <> 0 and erh.report_header_id = cct.report_header_id and NVL(erh.vouchno, 0) = 0 and AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode( erh.source,erh.workflow_approved_flag,erh.report_header_id) in ('SAVED', 'INPROGRESS','EMPAPPR', 'REJECTED', 'RESOLUTN', 'RETURNED', 'PENDMGR', 'MGRAPPR','ERROR','INVOICED','WITHDRAWN') and ac.card_program_id = cct.card_program_id and ac.card_id = cct.card_id and cp.card_program_id = cct.card_program_id and ac.employee_id = emp.person_id and emp.person_id = pera.person_id and pera.primary_flag='Y' and pera.assignment_status_type_id = peras.assignment_status_type_id and peras.per_system_status = 'ACTIVE_ASSIGN' and trunc(sysdate) between pera.effective_start_date and pera.effective_end_date &lp_min_amt_where &lp_emp_mgr UNION ALL select distinct emp.person_id age_employee_id, pera.supervisor_id age_supervisor_id, 'Active' age_emp_status, nvl(cct.billed_date,cct.posted_date) age_billed_date, cct.posted_date age_posted_date, cct.billed_amount aging_amount, 'UNUSED' aging_report_status_code, 'N' dispute_flag, cct.trx_id trx_id, cct.posted_date posted_date, cct.billed_amount billed_amount, emp.person_id from ap_credit_card_trxns cct, ap_cards_all ac, ap_card_programs_all cp, per_all_people_f emp, per_assignments_f pera, per_assignment_status_types peras where cct.card_program_id = :p_card_program_id and cct.validate_code = 'Y' and cct.payment_flag <> 'Y' and nvl(cct.category,'BUSINESS') not in ( 'DISPUTED','PERSONAL', 'DEACTIVATED','MATCHED','CREDIT') and nvl(cct.expensed_amount, 0) = 0 and cct.report_header_id IS NULL and ac.card_program_id = cct.card_program_id and ac.card_id = cct.card_id and cp.card_program_id = cct.card_program_id and ac.employee_id = emp.person_id and emp.person_id = pera.person_id and pera.primary_flag='Y' and pera.assignment_status_type_id = peras.assignment_status_type_id and peras.per_system_status = 'ACTIVE_ASSIGN' and trunc(sysdate) between pera.effective_start_date and pera.effective_end_date &lp_min_amt_where &lp_emp_mgr UNION ALL select distinct perf.person_id, pera.supervisor_id, 'Inactive', nvl(cct.billed_date, cct.posted_date), decode(cct.category,'DISPUTED',cct.posted_date+nvl(:p_grace_days,0),cct.posted_date), cct.billed_amount, nvl(AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source, erh.workflow_approved_flag,erh.report_header_id),'UNUSED') , 'N' dispute_flag, cct.trx_id trx_id, cct.posted_date posted_date, cct.billed_amount billed_amount, perf.person_id from ap_credit_card_trxns cct, ap_cards_all ac, ap_card_programs_all cp, ap_expense_report_headers erh, per_all_people_f perf, per_assignments_f pera, per_assignment_status_types peras where cct.card_program_id = :p_card_program_id and cct.validate_code = 'Y' and cct.payment_flag <> 'Y' and nvl(cct.category, 'BUSINESS') <> 'DEACTIVATED' and erh.report_header_id = cct.report_header_id and nvl(cct.expensed_amount, 0) <> 0 and NVL(erh.vouchno, 0) = 0 and nvl( AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode( erh.source,erh.workflow_approved_flag,erh.report_header_id), 'UNUSED') in ('UNUSED','SAVED', 'INPROGRESS','EMPAPPR', 'REJECTED', 'RESOLUTN', 'RETURNED', 'PENDMGR', 'MGRAPPR','ERROR','INVOICED','WITHDRAWN') and ac.card_program_id = cct.card_program_id and ac.card_id = cct.card_id and cp.card_program_id = cct.card_program_id and nvl(cct.billed_date,cct.posted_date) between nvl(:p_billed_start_date, nvl(cct.billed_date,cct.posted_date)-1) and nvl(:p_billed_end_date, nvl(cct.billed_date,cct.posted_date)+1) &lp_min_amt_where and ac.employee_id = perf.person_id &lp_emp_mgr1 and perf.person_id = pera.person_id and pera.assignment_type = 'E' and pera.primary_flag = 'Y' and perf.employee_number is not null and pera.assignment_status_type_id = peras.assignment_status_type_id and peras.per_system_status in ( 'TERM_ASSIGN', 'SUSP_ASSIGN') and trunc(sysdate) between perf.effective_start_date and perf.effective_end_date and trunc(sysdate) between pera.effective_start_date and pera.effective_end_date UNION ALL select distinct perf.person_id, pera.supervisor_id, 'Inactive', nvl(cct.billed_date,cct.posted_date), decode(cct.category,'DISPUTED',cct.posted_date+nvl(:p_grace_days,0),cct.posted_date), cct.billed_amount, 'UNUSED' , 'N' dispute_flag, cct.trx_id trx_id, cct.posted_date posted_date, cct.billed_amount billed_amount, perf.person_id from ap_credit_card_trxns cct, ap_cards_all ac, ap_card_programs_all cp, per_all_people_f perf, per_assignments_f pera, per_assignment_status_types peras where cct.card_program_id = :p_card_program_id and cct.validate_code = 'Y' and cct.payment_flag <> 'Y' and nvl(cct.category, 'BUSINESS') <> 'DEACTIVATED' and nvl(cct.expensed_amount, 0) = 0 and cct.report_header_id IS NULL and ac.card_program_id = cct.card_program_id and ac.card_id = cct.card_id and cp.card_program_id = cct.card_program_id and nvl(cct.billed_date,cct.posted_date) between nvl(:p_billed_start_date, nvl(cct.billed_date,cct.posted_date)-1) and nvl(:p_billed_end_date, nvl(cct.billed_date,cct.posted_date)+1) &lp_min_amt_where and ac.employee_id = perf.person_id &lp_emp_mgr1 and perf.person_id = pera.person_id and pera.assignment_type = 'E' and pera.primary_flag = 'Y' and perf.employee_number is not null and pera.assignment_status_type_id = peras.assignment_status_type_id and peras.per_system_status in ( 'TERM_ASSIGN', 'SUSP_ASSIGN') and trunc(sysdate) between perf.effective_start_date and perf.effective_end_date and trunc(sysdate) between pera.effective_start_date and pera.effective_end_date UNION ALL select distinct emp.person_id age_employee_id, pera.supervisor_id age_supervisor_id, 'Active' age_emp_status, nvl(cct.billed_date,cct.posted_date) age_billed_date, cct.posted_date+nvl(:p_grace_days,0) age_posted_date, cct.billed_amount aging_amount, 'DISPUTED' aging_report_status_code, 'Y' dispute_flag, cct.trx_id trx_id, cct.posted_date posted_date, cct.billed_amount billed_amount, emp.person_id from ap_credit_card_trxns cct, ap_cards_all ac, ap_card_programs_all cp, per_all_people_f emp, per_assignments_f pera, per_assignment_status_types peras where cct.card_program_id = :p_card_program_id and cct.validate_code = 'Y' and cct.payment_flag <> 'Y' and nvl(cct.category,'BUSINESS') = 'DISPUTED' and nvl(cct.expensed_amount,0) = 0 and ac.card_program_id = cct.card_program_id and ac.card_id = cct.card_id and cp.card_program_id = cct.card_program_id and ac.employee_id = emp.person_id and emp.person_id = pera.person_id and pera.primary_flag = 'Y' and pera.assignment_status_type_id = peras.assignment_status_type_id and peras.per_system_status = 'ACTIVE_ASSIGN' and trunc(sysdate) between pera.effective_start_date and pera.effective_end_date &lp_min_amt_where &lp_emp_mgr) SQLAP APXCCOUT_XML US AP Credit Card Outstanding Transactions Management (Details)- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Credit Card Outstanding Transactions Management (Details) Application: Payables Source: Credit Card Outstanding Transactions Management (Details) (XML) - Not Supported: Reserved For Future Use Short Name: APXCCOUT_XML DB package: AP_APXCCOUT_XMLP_PKG BI Publisher &lp_emp_mgr &lp_emp_mgr1 &lp_min_amt_where :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :cp_1 :cp_age_emp_name :cp_age_sup_name :cp_ap_unapproved :cp_appr_pend_bucket1 :cp_appr_pend_bucket2 :cp_appr_pend_bucket3 :cp_appr_pend_bucket4 :cp_appr_pending :cp_bucket1 :cp_bucket1_name :cp_bucket2 :cp_bucket2_name :cp_bucket3 :cp_bucket3_name :cp_bucket4 :cp_bucket4_name :cp_card_program_name :cp_chart_of_accounts_id :cp_company_name_header :cp_disputed :cp_emp_appr :cp_emp_name_summ :cp_emp_pend_bucket1 :cp_emp_pend_bucket2 :cp_emp_pend_bucket3 :cp_emp_pend_bucket4 :cp_emp_pending :cp_error :cp_invoiced :cp_masked_card_number :cp_mgr_pend_bucket1 :cp_mgr_pend_bucket2 :cp_mgr_pend_bucket3 :cp_mgr_pend_bucket4 :cp_mgr_pending :cp_mgr_unapproved :cp_nls_all :cp_nls_ap_unapproved :cp_nls_disputed :cp_nls_end_of_report :cp_nls_mgr_unapproved :cp_nls_no :cp_nls_no_data_found :cp_nls_rejected :cp_nls_unsubmitted :cp_nls_yes :cp_rejected :cp_report_title :cp_resolutn :cp_returned :cp_saved :cp_sup_pend_bucket1 :cp_sup_pend_bucket2 :cp_sup_pend_bucket3 :cp_sup_pend_bucket4 :cp_supervisor_name :cp_sys_pend_bucket1 :cp_sys_pend_bucket2 :cp_sys_pend_bucket3 :cp_sys_pend_bucket4 :cp_sys_pending :cp_unsubmitted :cp_withdrawn :cs_sup_bucket1 :cs_sup_bucket2 :cs_sup_bucket3 :cs_sup_bucket4 :lp_emp_mgr :lp_emp_mgr1 :lp_employee_from :lp_employee_status :lp_employee_where :lp_group_by :lp_inactive_where :lp_min_amt_where :lp_select_emp :lp_select_emp_name :lp_select_sup :operating_unit :p_billed_end_date :p_billed_start_date :p_bucket1 :p_bucket2 :p_bucket3 :p_bucket4 :p_card_program_id :p_conc_request_id :p_employee :p_esc_level :p_grace_days :p_include_directs :p_manager :p_min_amount :p_min_precision :p_operation_type :p_send_notifications :p_status :p_trace_switch 1 -50 :p_operation_type LOV Oracle AP_SRS_CC_OPERATION_TYPES Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where lookup_type='AP_CC_OPERATION_TYPES' order by value,description select displayed_field from ap_lookup_codes where lookup_type = 'AP_CC_OPERATION_TYPES' and lookup_code = 'CC_DETAIL_REPORT' Y US Operation Operation 2 -30 :p_dummy Number select 1 from dual where :$flex$.employee_status in ('B','C') and :$flex$.employee_name:null is null US FND_NUMBER Dummy Send Notifications 3 -40 :p_dummy_direct_reports Number select 1 from dual where :$flex$.employee_name:null is not null US FND_NUMBER Dummy Direct Reports 4 -20 :p_trace_switch LOV Oracle AP_SRS_YES_NO_OPT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' Y US Trace Switch Trace Switch 5 0 :operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 6 10 :p_card_program_id LOV Oracle AP_SRS_CARD_PROGRAM_NAME Y select card_program_id id, card_program_name value, null description from ap_card_programs order by value,description Y US Card Program Card Program 7 20 :p_status LOV Oracle AP_CC_EMPLOYEE_TYPES_LOV Y select lookup_code id, meaning value, null description from fnd_lookup_values where lookup_type='AP_CC_EMPLOYEE_TYPES' and enabled_flag='Y' and userenv('LANG')=language order by value,description select meaning from fnd_lookup_values where lookup_type = 'AP_CC_EMPLOYEE_TYPES' and lookup_code = 'C' and userenv('LANG') = language US Employee Status Employee Status 8 30 :p_employee LOV Oracle AP_SRS_EMPLOYEES_LOV Y select perf.person_id id, perf.full_name value, null description from per_people_f perf,per_person_types ppt where ((:$flex$.ap_cc_employee_types_lov='C' and trunc(sysdate) between perf.effective_start_date and perf.effective_end_date) or (:$flex$.ap_cc_employee_types_lov='T' and trunc(sysdate)>=perf.effective_end_date) or (:$flex$.ap_cc_employee_types_lov='B' and perf.effective_end_date=(select max(effective_end_date) from per_people_f p where p.person_id=perf.person_id))) and perf.employee_number is not null and perf.person_type_id=ppt.person_type_id and ppt.system_person_type in ('EMP','EMP_APL','EX_EMP','EX_EMP_APL') order by value,description US Employee Name Employee Name 9 40 :p_include_directs LOV Oracle OIE_SRS_CC_DETAILS Y select lookup_code id, meaning value, null description from fnd_lookups where (:$flex$.fnd_number is not null) and lookup_type='YES_NO' order by value,description Y US Include Direct Reports Include Direct Reports 10 50 :p_send_notifications LOV Oracle OIE_SRS_DET_NOTIFICATIONS Y select lookup_code id, displayed_field value, null description from ap_lookup_codes alc where alc.lookup_type='OIE_SRS_SEND_NOTIFICATION' and lookup_code in ('E','EM','N') and (:$flex$.fnd_number is not null) order by value,description select displayed_field from ap_lookup_codes where lookup_type = 'OIE_SRS_SEND_NOTIFICATION' and lookup_code = 'N' US Send Notifications Send Notifications 11 60 :p_min_amount Number US Minimum Transaction Amount Minimum Transaction Amount 12 70 :p_billed_start_date Date US Billed Start Date Billed Start Date 13 80 :p_billed_end_date Date US Billed End Date Billed End Date :$flex$.ap_cc_employee_types_lov Employee Status Employee Name :$flex$.employee_status Employee Status FND_NUMBER :$flex$.fnd_number FND_NUMBER Include Direct Reports :$flex$.fnd_number FND_NUMBER Send Notifications