AP Invoice Transaction Check Report- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Japanese Invoice Transaction Check Report
Application: Payables
Source: Invoice Transaction Check Report (XML) - Not Supported: Reserved For Future Use
Short Name: APXINVTC_XML
DB package: AP_APXINVTC_XMLP_PKG
Description: Japanese Invoice Transaction Check Report
Application: Payables
Source: Invoice Transaction Check Report (XML) - Not Supported: Reserved For Future Use
Short Name: APXINVTC_XML
DB package: AP_APXINVTC_XMLP_PKG
Run
AP Invoice Transaction Check Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Operating Unit |
|
LOV | |
Start Update Date |
|
Date | |
End Update Date |
|
Date | |
Invoice Type |
|
LOV Oracle | |
Supplier |
|
LOV Oracle | |
Updated by |
|
LOV Oracle |