DBA Data[Home] [Help]

APPS.JG_ZZ_SUMMARY_AR_PKG dependencies on AR_CASH_RECEIPTS_ALL

Line 802: FROM ar_cash_receipts_all ac,

798: ac.currency_code CURRENCT_CODE,
799: round(ac.amount * (1 - 1/(1 + at.PERCENTAGE_RATE/100.0)),2) R_TAX,
800: -1 * round(ac.amount * (1 - 1/(1 + at.PERCENTAGE_RATE/100.0)),2) REV_TAX,
801: aa.cash_receipt_id CASH_RECEIPT_ID
802: FROM ar_cash_receipts_all ac,
803: ar_receivable_applications_all aa,
804: zx_rates_b at
805: WHERE aa.cash_receipt_id = ac.cash_receipt_id
806: AND ac.org_id = aa.org_id

Line 861: ar_cash_receipts_all ac,

857: at.tax_rate_id TAX_RATE_ID
858: -- ac.RECEIPT_NUMBER
859: FROM ar_receivable_applications_all aa,
860: zx_rates_b at,
861: ar_cash_receipts_all ac,
862: ra_customer_trx tr,
863: hz_cust_accounts rc,
864: hz_parties hzp,
865: hz_cust_acct_sites cs,