View: AR_FUNDS_CAPTURE_ORDERS_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_FUNDS_CAPTURE_ORDERS_V

View Text

SELECT CR.SELECTED_REMITTANCE_BATCH_ID SELECTED_REMITTANCE_BATCH_ID
, NVL(INTRM.CURRENT_WORKER
, 0) WORKER_ID
, /* BUG 7133142 */ 'AR_'||CR.SELECTED_REMITTANCE_BATCH_ID
, CR.RECEIPT_DATE
, PS.DUE_DATE
, NULL
, NULL
, CR.CURRENCY_CODE
, CR.AMOUNT
, CR.PAYMENT_TRXN_EXTENSION_ID
, BAU.BANK_ACCOUNT_ID
, PARTY.PARTY_ID
, CR.PAY_FROM_CUSTOMER
, CR.CUSTOMER_SITE_USE_ID
, CR.ORG_ID
, 'OPERATING_UNIT'
, CR.LEGAL_ENTITY_ID
, LOC.LOCATION_ID
, NULL
, CR.PAYMENT_SERVER_ORDER_NUM
, NULL
, NULL
, NULL
, CR.ATTRIBUTE_CATEGORY
, CR.ATTRIBUTE1
, CR.ATTRIBUTE2
, CR.ATTRIBUTE3
, CR.ATTRIBUTE4
, CR.ATTRIBUTE5
, CR.ATTRIBUTE6
, CR.ATTRIBUTE7
, CR.ATTRIBUTE8
, CR.ATTRIBUTE9
, CR.ATTRIBUTE10
, CR.ATTRIBUTE11
, CR.ATTRIBUTE12
, CR.ATTRIBUTE13
, CR.ATTRIBUTE14
, CR.ATTRIBUTE15
, CR.CREATED_BY
, CR.CREATION_DATE
, CR.LAST_UPDATED_BY
, CR.LAST_UPDATE_DATE
, CR.LAST_UPDATE_LOGIN
, 1
, CR.RECEIPT_METHOD_ID
FROM AR_CASH_RECEIPTS CR
, AR_AUTOREM_INTERIM INTRM
, /* BUG 7133142 */ HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS HCA
, HZ_LOCATIONS LOC
, HZ_CUST_ACCT_SITES ACCT_SITE
, HZ_PARTY_SITES PARTY_SITE
, HZ_CUST_SITE_USES SU
, AR_RECEIPT_CLASSES RC
, AR_RECEIPT_METHODS RM
, AR_PAYMENT_SCHEDULES PS
, CE_BANK_ACCT_USES_OU_V BAU
WHERE CR.CASH_RECEIPT_ID = INTRM.CASH_RECEIPT_ID(+) /*BUG 7133142*/
AND CR.SELECTED_REMITTANCE_BATCH_ID = INTRM.BATCH_ID(+) /* BUG 7133142 */
AND HCA.PARTY_ID = PARTY.PARTY_ID
AND HCA.CUST_ACCOUNT_ID = CR.PAY_FROM_CUSTOMER
AND SU.SITE_USE_ID(+) = CR.CUSTOMER_SITE_USE_ID
AND ACCT_SITE.CUST_ACCT_SITE_ID(+) = SU.CUST_ACCT_SITE_ID
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID(+)
AND LOC.LOCATION_ID(+) = PARTY_SITE.LOCATION_ID
AND CR.RECEIPT_METHOD_ID = RM.RECEIPT_METHOD_ID
AND RM.RECEIPT_CLASS_ID = RC.RECEIPT_CLASS_ID
AND RC.CREATION_METHOD_CODE = 'AUTOMATIC'
AND CR.PAYMENT_TRXN_EXTENSION_ID IS NOT NULL
AND CR.TYPE = 'CASH'
AND PS.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
AND BAU.BANK_ACCT_USE_ID = CR.REMIT_BANK_ACCT_USE_ID

Columns