AP Period Close Exceptions

Description
Categories: BI Publisher, Financials, Procurement
Application: Payables
Source: Period Close Exceptions Report (XML)
Short Name: APXPCER_XMLP
DB package: ap_period_close_pkg
			SELECT DISTINCT
			       GTT.org_id CUT_ORG_ID,
				   to_char(GTT.accounting_date,'DD-Mon-RRRR') CUT_ACCT_DATE,
				   GTT.event_type_code CUT_EVENT,
    			   NVL(AP.vendor_name, HP.party_name) CUT_SUPPLIER,
				   GTT.invoice_num     CUT_DOC_NUM
    		  FROM ap_period_close_excps_gt	GTT,
        		   ap_invoices_all AI,
 			       ap_suppliers AP,
			       HZ_PARTIES HP
			 WHERE GTT.SOURCE_TYPE = 'UNTRANSFERED_HEADERS'
			   AND GTT.source_table_name = 'XLA_AE_HEADERS'
			   AND GTT.entity_code = 'AP_INVOICES'
			   AND GTT.invoice_id = AI.invoice_id(+)
			   AND AI.Vendor_ID= AP.vendor_id(+)
			   AND AI.party_id=HP.party_id(+)
			   AND GTT.org_id = :org_id
			UNION
			SELECT DISTINCT
			       GTT.org_id CUT_ORG_ID,
				   to_char(GTT.accounting_date,'DD-Mon-RRRR') CUT_ACCT_DATE,
				   GTT.event_type_code CUT_EVENT,
    			   NVL(AP.vendor_name, HP.party_name) CUT_SUPPLIER,
				   TO_CHAR(GTT.check_number) CUT_DOC_NUM
    		  FROM ap_period_close_excps_gt	gtt,
			  	   ap_checks_all AC,
 			       ap_suppliers AP,
			       HZ_PARTIES HP
			 WHERE GTT.SOURCE_TYPE = 'UNTRANSFERED_HEADERS'
			   AND GTT.source_table_name = 'XLA_AE_HEADERS'
			   AND GTT.entity_code = 'AP_PAYMENTS'
			   AND GTT.check_id = AC.check_id(+)
			   AND AC.vendor_id = AP.vendor_id(+)
			   AND AC.party_id=HP.party_id(+)
			   AND GTT.org_id = :org_id
             UNION
			SELECT DISTINCT 
			       GTT.org_id CUT_ORG_ID,
				   to_char(GTT.accounting_date,'DD-Mon-RRRR') CUT_ACCT_DATE,
				   GTT.event_type_code CUT_EVENT,
    			   NULL CUT_SUPPLIER,
				   TO_CHAR(GTT.INVOICE_NUM) CUT_DOC_NUM
    		  FROM ap_period_close_excps_gt	gtt
			 WHERE GTT.SOURCE_TYPE = 'UNTRANSFERED_HEADERS'
			   AND GTT.source_table_name = 'XLA_AE_HEADERS'
			   AND GTT.entity_code = 'MANUAL'
			   AND GTT.org_id = :org_id
Parameter Name SQL text Validation
Debug Switch
 
LOV Oracle
Action
 
Ledger ID
 
Number
Period Name
 
LOV Oracle
To Accounting Date
 
Date
From Accounting Date
 
Date
Ask a question