APPS.JG_ZZ_SUMMARY_AR_PKG dependencies on RA_CUSTOMER_TRX

Line 816: FROM ra_customer_trx_all trx1, ra_cust_trx_types_all type1

812: AND (ac.vat_tax_id = P_TAX_RATE_ID OR P_TAX_RATE_ID IS NULL)
813: AND ( (aa.status = 'ACC')
814: OR (aa.applied_customer_trx_id IN(
815: SELECT trx1.customer_trx_id
816: FROM ra_customer_trx_all trx1, ra_cust_trx_types_all type1
817: WHERE trx1.cust_trx_type_id = type1.cust_trx_type_id
818: AND trx1.org_id = type1.org_id
819: AND type1.type ='DEP' ) ) )
820: AND (ac.receipt_date between

Line 836: FROM ra_customer_trx trx2, ra_cust_trx_types type2

832: AND a1.status = 'APP'
833: AND ( (a2.status = 'ACC')
834: OR (a2.applied_customer_trx_id IN(
835: SELECT trx2.customer_trx_id
836: FROM ra_customer_trx trx2, ra_cust_trx_types type2
837: WHERE trx2.cust_trx_type_id = type2.cust_trx_type_id
838: AND type2.type ='DEP' ) ) )
839: AND a1.cash_receipt_id = a2.cash_receipt_id
840: AND a1.org_id = a2.org_id))

Line 862: ra_customer_trx tr,

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,
866: hz_cust_site_uses csu