eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: ARBR_FUNDS_CAPTURE_ORDERS_V

Product:	AR - Receivables
Description:	Creation of ARBR_FUNDS_CAPTURE_ORDERS_V view this is view is required for payment settlemnt
Implementation/DBA Data:	APPS.ARBR_FUNDS_CAPTURE_ORDERS_V

View Text

SELECT 'ARBR_'||TRX.REMITTANCE_BATCH_ID
, BAT.BATCH_DATE
, NULL
, PS.DUE_DATE
, CTT.NAME
, PS.INVOICE_CURRENCY_CODE
, TRX.BR_AMOUNT
, TRX.PAYMENT_TRXN_EXTENSION_ID
, BAU.BANK_ACCOUNT_ID
, PARTY.PARTY_ID
, CUST_ACCT.CUST_ACCOUNT_ID
, TRX.DRAWEE_SITE_USE_ID
, TRX.ORG_ID
, 'OPERATING_UNIT'
, TRX.LEGAL_ENTITY_ID
, PARTY_SITE.LOCATION_ID
, TRX.CUSTOMER_REFERENCE
, CTT.DRAWEE_ISSUED_FLAG
, CTT.SIGNED_FLAG
, DECODE (TRH.STATUS
, 'PROTESTED'
, 'Y'
, 'N')
, TRX.ATTRIBUTE_CATEGORY
, TRX.ATTRIBUTE1
, TRX.ATTRIBUTE2
, TRX.ATTRIBUTE3
, TRX.ATTRIBUTE4
, TRX.ATTRIBUTE5
, TRX.ATTRIBUTE6
, TRX.ATTRIBUTE7
, TRX.ATTRIBUTE8
, TRX.ATTRIBUTE9
, TRX.ATTRIBUTE10
, TRX.ATTRIBUTE11
, TRX.ATTRIBUTE12
, TRX.ATTRIBUTE13
, TRX.ATTRIBUTE14
, TRX.ATTRIBUTE15
, TRX.CREATED_BY
, TRX.CREATION_DATE
, TRX.LAST_UPDATED_BY
, TRX.LAST_UPDATE_DATE
, TRX.LAST_UPDATE_LOGIN
, 1
, BAT.RECEIPT_METHOD_ID
FROM AR_PAYMENT_SCHEDULES PS
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
, RA_CUST_TRX_TYPES CTT
, RA_CUSTOMER_TRX TRX
, AR_TRANSACTION_HISTORY TRH
, AR_BATCHES BAT
, HZ_CUST_ACCT_SITES ACCT_SITE
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_CUST_SITE_USES SU
, CE_BANK_ACCT_USES_OU_V BAU
WHERE PS.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND TRX.BR_AMOUNT IS NOT NULL
AND NVL(TRH.CURRENT_RECORD_FLAG
, 'Y') = 'Y'
AND PS.CUSTOMER_TRX_ID = TRH.CUSTOMER_TRX_ID
AND BAT.BATCH_ID = TRX.REMITTANCE_BATCH_ID
AND TRX.DRAWEE_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND PS.CUST_TRX_TYPE_ID = CTT.CUST_TRX_TYPE_ID
AND CTT.TYPE = 'BR'
AND TRX.DRAWEE_SITE_USE_ID = SU.SITE_USE_ID
AND SU.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND CUST_ACCT.CUST_ACCOUNT_ID=ACCT_SITE.CUST_ACCOUNT_ID
AND BAU.BANK_ACCT_USE_ID = TRX.REMIT_BANK_ACCT_USE_ID

Columns

Name
CALL_APP_SERVICE_REQ_CODE
SETTLEMENT_DATE
SETTLEMENT_DUE_DATE
BR_MATURITY_DATE
ORDER_DESCRIPTION
SETTLEMENT_CURRENCY_CODE
SETTLEMENT_AMOUNT
PAYMENT_TRXN_EXTENSION_ID
INTERNAL_BANK_ACCOUNT_ID
PAYER_PARTY_ID
CUST_ACCOUNT_ID
ACCT_SITE_USE_ID
ORG_ID
ORG_TYPE
LEGAL_ENTITY_ID
BILL_TO_ADDRESS_ID
SETTLEMENT_CUSTOMER_REFERENCE
BR_DRAWEE_ISSUED_FLAG
BR_SIGNED_FLAG
BR_DISPUTED_FLAG
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
AR_RECEIPT_METHOD_ID