ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4721E51A9E05362FB09050512 SELECT emp.full_name C_FULL_NAME, icc.masked_cc_number C_TRX_CARD_NUMBER, txn.posted_date C_TRX_POSTED_DATE, txn.transaction_amount C_TRX_AMOUNT, txn.trx_id C_TRX_ID, txn.posted_currency_code C_CURRENCY_CODE, txn.merchant_name1 C_MERCHANT_NAME, AP_WEB_DB_CCARD_PKG.GETLOCATION(txn.merchant_city, txn.merchant_province_state) C_LOCATION, vendor.vendor_name C_VENDOR_NAME, AP_APXCCPUT_XMLP_PKG.c_trx_amount_fformula(:C_TRX_AMOUNT_F) C_TRX_AMOUNT_F, AP_APXCCPUT_XMLP_PKG.cf_masked_card_numberformula(icc.masked_cc_number) CF_MASKED_CARD_NUMBER, AP_APXCCPUT_XMLP_PKG.CP_MASKED_CARD_NUMBER_p CP_MASKED_CARD_NUMBER, '1' dummy from per_employees_x emp, ap_cards_all card, ap_credit_card_trxns_all txn, po_vendors vendor, ap_card_programs_all card_prog, iby_creditcard icc where txn.inactive_emp_wf_item_key is null and txn.org_id = nvl(:p_org_id, txn.org_id) and txn.card_id = nvl(:p_card_number, txn.card_id) and txn.transaction_amount = nvl(:p_amount, txn.transaction_amount) and txn.posted_date between (nvl(:lp_start_date, txn.posted_date-1)) and :lp_end_date and ( ( txn.report_header_id is null and txn.category is null and :p_process='DEACTIVATE') or (txn.report_header_id = -1 and txn.category = 'DEACTIVATED' and :p_process= 'ACTIVATE')) and card.card_program_id = txn.card_program_id and txn.card_id = card.card_id and card.employee_id = emp.employee_id and card.card_program_id = card_prog.card_program_id and card_prog.vendor_id = vendor.vendor_id and txn.org_id = card_prog.org_id and card.card_reference_id = icc.instrid order by txn.posted_date Y SQLAP APXCCPUT_XML US AP Credit Card Historical Transactions Management- Not Supported: Reserved For Future Use Imported from BI Publisher Application: Payables Source: Credit Card Historical Transactions Management (XML) - Not Supported: Reserved For Future Use Short Name: APXCCPUT_XML DB package: AP_APXCCPUT_XMLP_PKG BI Publisher :c_nls_all :c_nls_end_of_report :c_nls_no :c_nls_no_data_exists :c_nls_yes :c_organization_name :c_trx_amount_f :cp_masked_card_number :lp_end_date :lp_start_date :p_amount :p_card_number :p_conc_request_id :p_debug_switch :p_end_date :p_org_id :p_process :p_send_notifications :p_start_date :p_trace_switch 1 -40 :p_dummy_send_notification Number select 1 from dual where :$flex$.process = 'DEACTIVATE' US FND_NUMBER Dummy Send Notification 2 -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' US Trace Switch Trace Switch 3 10 :p_process LOV Oracle OIE_CC_PROCESS_TYPES Y select lookup_code id, displayed_field value, description description from ap_lookup_codes where lookup_type='OIE_CC_PROCESS_TYPES' order by value,description select displayed_field from ap_lookup_codes where lookup_type='OIE_CC_PROCESS_TYPES' and lookup_code='DEACTIVATE' Y US Process Process 4 20 :p_start_date Date US Posted Start Date Posted Start Date 5 30 :p_end_date Date Y US Posted End Date Posted End Date 6 40 :p_org_id LOV Oracle OIE_SRS_OPERATING_UNIT Y select organization_id id, name value, null description from hr_operating_units where mo_global.check_access(organization_id)='Y' order by value,description US Operating Unit Operating Unit 7 50 :p_card_number LOV Oracle OIE_SRS_CARD_NUMBER Y select card_id id, card_number value, null description from oie_srs_card_number_v where org_id=nvl(:$flex$.oie_srs_operating_unit:null,org_id) and org_id in (select organization_id from hr_operating_units where mo_global.check_access(organization_id)='Y') order by value,description US Card Number Card Number 8 60 :p_amount Number US Transaction Amount Transaction Amount 9 70 :p_send_notifications 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 select meaning from FND_LOOKUPS where lookup_type='YES_NO' and lookup_code='N' US Send Notification Send Notification