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
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