ARB_FUNDS_CAPTURE_ORDERS

Details

Schema: FUSION
Object owner: ARB
Object type: VIEW

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 RECEIPT_METHOD_ID STRUCTURED_PAYMENT_REFERENCE

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

RECEIPT_METHOD_ID

STRUCTURED_PAYMENT_REFERENCE

Query

SQL_Statement
SELECT 'ARB_' \|\| cr.cash_receipt_id AS call_app_service_req_code, cr.receipt_date AS settlement_date, ps.due_date AS settlement_due_date, NULL AS br_maturity_date, NULL AS order_description, cr.currency_code AS settlement_currency_code, cr.amount AS settlement_amount, cr.payment_trxn_extension_id AS payment_trxn_extension_id, bau.bank_account_id AS internal_bank_account_id, party.party_id AS payer_party_id, cr.pay_from_customer AS cust_account_id, cr.customer_site_use_id AS acct_site_use_id, cr.org_id, 'OPERATING_UNIT' AS org_type, cr.legal_entity_id, loc.location_id AS bill_to_address_id, NULL AS settlement_customer_reference, NULL AS br_drawee_issued_flag, NULL AS br_signed_flag, NULL AS br_disputed_flag, 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 OBJECT_VERSION_NUMBER , cr.receipt_method_id, NULL STRUCTURED_PAYMENT_REFERENCE FROM ar_cash_receipts cr, hz_parties party, hz_cust_accounts hca, hz_locations loc, hz_cust_acct_sites_all acct_site, hz_party_sites party_site, hz_cust_site_uses_all su, ar_receipt_methods rm, ar_payment_schedules ps, ce_bank_acct_uses_ou_v bau WHERE 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 (su.set_id = FND_SetID_Utility.getSetID('HZ_CUSTOMER_ACCOUNT_SITE', 'BU', mo_global.get_current_org_id) OR nvl(su.set_id, 0) = 0) AND (su.set_id = acct_site.set_id OR nvl(acct_site.set_id, 0) = 0) 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 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

SQL_Statement

SELECT 'ARB_' || cr.cash_receipt_id AS call_app_service_req_code,

cr.receipt_date AS settlement_date,

ps.due_date AS settlement_due_date,

NULL AS br_maturity_date,

NULL AS order_description,

cr.currency_code AS settlement_currency_code,

cr.amount AS settlement_amount,

cr.payment_trxn_extension_id AS payment_trxn_extension_id,

bau.bank_account_id AS internal_bank_account_id,

party.party_id AS payer_party_id,

cr.pay_from_customer AS cust_account_id,

cr.customer_site_use_id AS acct_site_use_id,

cr.org_id,

'OPERATING_UNIT' AS org_type,

cr.legal_entity_id,

loc.location_id AS bill_to_address_id,

NULL AS settlement_customer_reference,

NULL AS br_drawee_issued_flag,

NULL AS br_signed_flag,

NULL AS br_disputed_flag,

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 OBJECT_VERSION_NUMBER ,

cr.receipt_method_id,

NULL STRUCTURED_PAYMENT_REFERENCE

FROM ar_cash_receipts cr, hz_parties party, hz_cust_accounts hca, hz_locations loc,

hz_cust_acct_sites_all acct_site, hz_party_sites party_site, hz_cust_site_uses_all su,

ar_receipt_methods rm, ar_payment_schedules ps, ce_bank_acct_uses_ou_v bau

WHERE 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 (su.set_id = FND_SetID_Utility.getSetID('HZ_CUSTOMER_ACCOUNT_SITE', 'BU', mo_global.get_current_org_id) OR nvl(su.set_id, 0) = 0)

AND (su.set_id = acct_site.set_id OR nvl(acct_site.set_id, 0) = 0)

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 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