Oracle Fusion ERP – AP Payment Report Query

by admin

SELECT      
		    PSV.VENDOR_NAME                     VENDOR_NAME
		 ,  PSV.SEGMENT1                        VENDOR_NUMBER
		 ,  PSSV.PARTY_SITE_NAME                PARTY_SITE_NAME
		 ,  PSSV.COUNTRY                        COUNTRY
		 ,  ACA.PAYMENT_METHOD_CODE             PAYMENT_METHOD_CODE
		 ,  FLV.MEANING                         PAYMENT_METHOD_DESC
		 ,  ACA.CHECK_ID                        CHECK_ID
		 ,  ACA.AMOUNT                          CHECK_AMOUNT
		 ,  ACA.CHECK_NUMBER                    CHECK_NUMBER
         ,  TO_CHAR(ACA.CHECK_DATE , 'DD-Mon-RRRR')     CHECK_DATE
         ,  ACA.DOC_SEQUENCE_VALUE              CHECK_VOUCHER_NUM
		 ,  ACA.CHECK_NUMBER                    CHECK_DOCUMENT_SEQ
		 ,  ACA.LEGAL_ENTITY_ID                 LEGAL_ENTITY_ID
		 ,  XLP.NAME                            LEGAL_ENTITY_NAME
		 ,  CBA.BANK_ACCOUNT_NAME               BANK_ACCOUNT_NAME
		 ,  CBA.BANK_ACCOUNT_NUM                BANK_ACCOUNT_NUM
		 ,  FABV.BU_NAME                        BU_NAME
		 ,  ACA.CHECKRUN_NAME                   CHECKRUN_NAME
		 ,  GL.CURRENCY_CODE                    PRIMARY_LEDGER_CURRENCY
     
		 
FROM        AP_CHECKS_ALL               ACA 
         ,  POZ_SUPPLIERS_V             PSV
		 ,  POZ_SUPPLIER_SITES_V        PSSV
		 ,  FND_LOOKUP_VALUES           FLV
		 ,  XLE_ENTITY_PROFILES         XLP
		 ,  FUN_ALL_BUSINESS_UNITS_V    FABV
		 ,  GL_LEDGERS                  GL
		 ,  FND_DOCUMENT_SEQUENCES      FDS
		 ,  CE_BANK_ACCOUNTS    CBA
         ,  CE_BANK_ACCT_USES_ALL        CBAUA 
		 
		 
WHERE       ACA.VENDOR_ID  =  PSV.VENDOR_ID  
AND         PSSV.VENDOR_ID  =  PSV.VENDOR_ID
AND         PSSV.VENDOR_SITE_ID  =  ACA.VENDOR_SITE_ID 
AND         FLV.LOOKUP_CODE  =  ACA.PAYMENT_METHOD_CODE
AND         FLV.LOOKUP_TYPE  =  'PAYMENT METHOD'
AND         FLV.LANGUAGE  =  'US'
AND         XLP.LEGAL_ENTITY_ID  =  ACA.LEGAL_ENTITY_ID
AND         ACA.ORG_ID  =  FABV.BU_ID 
AND         FABV.PRIMARY_LEDGER_ID  =  GL.LEDGER_ID
AND         ACA.DOC_SEQUENCE_ID  =  FDS.DOC_SEQUENCE_ID  
AND         CBA.BANK_ACCOUNT_ID  =  CBAUA.BANK_ACCOUNT_ID
AND         ACA.CE_BANK_ACCT_USE_ID  = CBAUA.BANK_ACCT_USE_ID

AND         ACA.STATUS_LOOKUP_CODE <>  'VOIDED'

ORDER BY    ACA.CHECK_ID

Comments |0|

Legend *) Required fields are marked
**) You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
Category: Uncategorized