APPS.JE_REVERSE_SALES_LIST_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 61: ra_customer_trx_all ctrx,

57: zl.tax_registration_number CUST_VAT_REG_NUM
58: FROM
59: hz_cust_accounts hca,
60: hz_parties hp,
61: ra_customer_trx_all ctrx,
62: zx_lines zl
63: WHERE ctrx.legal_entity_id = P_LEGAL_ENTITY
64: AND ctrx.complete_flag = 'Y'
65: AND TRUNC(ctrx.trx_date) BETWEEN TRUNC(TO_DATE(P_FROM_DATE,'YYYY/MM/DD HH24:MI:SS'))

Line 116: FROM ra_customer_trx_all trx,

112: END IF;
113: BEGIN
114: SELECT ROUND(NVL(SUM(trx_lines.extended_amount),0))
115: INTO ln_sales_amount
116: FROM ra_customer_trx_all trx,
117: ra_customer_trx_lines_all trx_lines,
118: zx_lines lines,
119: ra_customer_trx_lines_all trx_tax_lines,
120: zx_report_codes_assoc zrc,