DBA Data[Home] [Help]

APPS.JAI_CMN_RPT_BBR_PKG dependencies on HZ_CUST_ACCOUNTS

Line 62: hz_cust_accounts rc,

58: SELECT SUM(DECODE(acrh.status, 'REVERSED',(acrh.amount*NVL(acrh.exchange_rate,1))*-1,
59: NVL(acrh.amount, 0)*NVL(acrh.exchange_rate,1))) INTO amt
60: FROM ar_cash_receipt_history_all acrh,
61: ar_cash_receipts_all acr,
62: hz_cust_accounts rc,
63: ce_bank_accounts ceba
64: WHERE acrh.cash_receipt_id = acr.cash_receipt_id
65: AND acr.remittance_bank_account_id = ceba.bank_account_id
66: AND acr.pay_from_customer = rc.cust_account_id (+)