AP Invoice Transaction Check - draft

Description
Categories: BI Publisher, Financials, Procurement
Application: Payables
Source: Invoice Transaction Check Report (XML) - Not Supported: Reserved For Future Use
Short Name: APXINVTC_XML
DB package: AP_APXINVTC_XMLP_PKG
select
            	AI.INVOICE_ID       		C_INVOICE_ID,  
 	AI.LAST_UPDATE_DATE               C_LAST_UPDATE_DATE, 
 	pv1.SEGMENT1                	C_SUPPLIER_CODE, 
          	decode(:h_sort_by_alternate, 'Y', pv1.VENDOR_NAME_ALT, 'N', pv1.VENDOR_NAME)   
                                                         	C_SUPPLIER_NAME, 
    	decode(:h_sort_by_alternate, 'Y', PVS.VENDOR_SITE_CODE_ALT, 'N',
                             PVS.VENDOR_SITE_CODE)  C_SUPPLIER_SITE, 
	pv1.VENDOR_NAME		C_SUPPLIER_NAME_DISP, 
	PVS.VENDOR_SITE_CODE	C_SUPPLIER_SITE_CODE_DISP, 
    	AI.INVOICE_NUM             	C_INVOICE_NUMBER, 
    	AI.INVOICE_DATE            	C_INVOICE_DATE, 
    	AI.INVOICE_CURRENCY_CODE   C_CURRENCY, 
    	AI.INVOICE_AMOUNT          	C_AMOUNT, 
    	AI.EXCHANGE_RATE           	C_EXCHANGE_RATE, 
      	 rpad( &H_ACCT_SEGS ,600)   	C_INVOICE_ACCT_SEGS,          	
    	FU.USER_NAME           	C_UPDATED_BY, 
    	ALC2.DISPLAYED_FIELD       	C_INVOICE_TYPE, 
     	FDS.NAME                   	C_SEQUENCE_NAME, 
    	AI.DOC_SEQUENCE_VALUE    	C_VOUCHER_NUMBER, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_lia_acct_flex', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_LIA_ACCT_FLEX, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_lia_acct_desc', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'ALL', 'Y', 'FULL_DESCRIPTION') C_LIA_ACCT_DESC
from 
	AP_INVOICES                	AI,      
                   PO_VENDORS              	pv1,     
                   PO_VENDOR_SITES               	PVS, 
	FND_USER                      	FU, 
    	AP_LOOKUP_CODES            	ALC2, 
    	FND_DOCUMENT_SEQUENCES	FDS, 
    	GL_CODE_COMBINATIONS    	GCC
where     
                   &H_INVOICE_WHERE
	trunc(AI.LAST_UPDATE_DATE) between trunc(:P_START_UPDATE_DATE) and trunc(:P_END_UPDATE_DATE) and
    	AI.SET_OF_BOOKS_ID = :P_SET_OF_BOOKS_ID and  
     	AI.VENDOR_ID = pv1.VENDOR_ID and
            	AI.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID and 
    	AI.LAST_UPDATED_BY = FU.USER_ID and 
    	AI.INVOICE_TYPE_LOOKUP_CODE = ALC2.LOOKUP_CODE and 
    	ALC2.LOOKUP_TYPE = 'INVOICE TYPE' and 
    	AI.ACCTS_PAY_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID and 
	AI.DOC_SEQUENCE_ID = FDS.DOC_SEQUENCE_ID (+)
order by
	AI.LAST_UPDATE_DATE, 
            	decode(:h_sort_by_alternate, 'Y', pv1.VENDOR_NAME_ALT, 'N', pv1.VENDOR_NAME),  
	decode(:h_sort_by_alternate, 'Y', PVS.VENDOR_SITE_CODE_ALT, 'N',
                             PVS.VENDOR_SITE_CODE), 
	AI.INVOICE_NUM
Ask a question
Parameter Name SQL text Validation
Ledger Id
 
Updated by
 
LOV Oracle
Supplier
 
LOV Oracle
Invoice Type
 
LOV Oracle
End Update Date
 
Date
Start Update Date
 
Date