[Home] [Help]
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, cr.seq_type_last, rc.remit_method_code 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
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
, CR.SEQ_TYPE_LAST
, RC.REMIT_METHOD_CODE
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
|
|
|
|