AP Procurement Card Transactions Validation Program - draft
Description
Categories: BI Publisher
Application: Payables
Source: Procurement Card Transactions Validation Program (XML) - Not Supported: Reserved For Future Use
Short Name: APXPCVAL_XML
DB package: AP_APXPCVAL_XMLP_PKG
Source: Procurement Card Transactions Validation Program (XML) - Not Supported: Reserved For Future Use
Short Name: APXPCVAL_XML
DB package: AP_APXPCVAL_XMLP_PKG
Run
AP Procurement Card Transactions Validation Program - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT null C_FLEXDATA, efd.PROFILE_NAME C_PROFILE_NAME, hremp.full_name C_FULL_NAME, efd.card_number C_TRX_CARD_NUMBER, efd.posted_date C_TRX_POSTED_DATE, efd.TRANSACTION_DATE C_TRX_TRANSACTION_DATE, efd.amount C_TRX_AMOUNT, efd.POSTED_CURRENCY_CODE C_TRX_POSTED_CURRENCY_CODE, efd.ORIGINAL_CURRENCY_CODE C_TRX_CURRENCY_CODE, efd.MERCHANT_NAME C_TRX_MERCHANT_NAME, efd.MERCHANT_NUMBER C_TRX_MERCHANT_NUMBER, efd.reference_number C_TRX_REFERENCE_NUMBER, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD from ap_expense_feed_dists_v efd, hr_employees_current_v hremp, gl_code_combinations g where hremp.employee_id = efd.employee_id AND (efd.dist_code_combination_id = g.code_combination_id(+)) and g.chart_of_accounts_id = :C_CHART_OF_ACCOUNTS_ID and efd.card_program_id = :P_CARD_PROGRAM_ID and efd.posted_date between nvl(:P_START_DATE, efd.posted_date-1) AND nvl(:P_END_DATE, efd.posted_date + 1) and :p_conc_request_id = efd.conc_request_id order by C_TRX_CARD_NUMBER,C_FULL_NAME,C_PROFILE_NAME,C_TRX_POSTED_DATE,C_TRX_TRANSACTION_DATE,C_TRX_REFERENCE_NUMBER,C_TRX_MERCHANT_NAME,C_TRX_MERCHANT_NUMBER,C_FLEXDATA,C_TRX_POSTED_CURRENCY_CODE,C_TRX_AMOUNT,C_TRX_CURRENCY_CODE |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Card Program |
|
LOV Oracle | |
Transaction Start Date |
|
Date | |
Transaction End Date |
|
Date |