APPS.JG_ZZ_SUMMARY_AR_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 803: ar_receivable_applications_all aa,

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
807: AND at.tax_rate_id = ac.vat_tax_id

Line 825: FROM ar_receivable_applications_all a1,

821: NVL(TO_DATE(P_GL_PERIOD_START_DATE ,'DD-MM-YYYY'),TO_DATE('01-01-1890' ,'DD-MM-YYYY'))
822: AND NVL(TO_DATE(P_GL_PERIOD_END_DATE,'DD-MM-YYYY'),TO_DATE('30-12-2099','DD-MM-YYYY'))
823: OR aa.cash_receipt_id IN
824: ( SELECT distinct a1.cash_receipt_id
825: FROM ar_receivable_applications_all a1,
826: ar_receivable_applications_all a2,
827: hz_cust_accounts rc
828: WHERE
829: DECODE(SIGN(a1.amount_applied),-1,a1.gl_date,a1.gl_date) BETWEEN

Line 826: ar_receivable_applications_all a2,

822: AND NVL(TO_DATE(P_GL_PERIOD_END_DATE,'DD-MM-YYYY'),TO_DATE('30-12-2099','DD-MM-YYYY'))
823: OR aa.cash_receipt_id IN
824: ( SELECT distinct a1.cash_receipt_id
825: FROM ar_receivable_applications_all a1,
826: ar_receivable_applications_all a2,
827: hz_cust_accounts rc
828: WHERE
829: DECODE(SIGN(a1.amount_applied),-1,a1.gl_date,a1.gl_date) BETWEEN
830: NVL(TO_DATE(P_GL_PERIOD_START_DATE,'DD-MM-YYYY'),TO_DATE('01-01-1890','DD-MM-YYYY'))

Line 859: FROM ar_receivable_applications_all aa,

855: SUBSTR(hzp.party_name,1,20) CUSTOMER_NAME,
856: SUBSTR(csu.location,1,20) LOCATION,
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,