APPS.JE_REVERSE_SALES_LIST_PKG dependencies on ZX_LINES

Line 62: zx_lines zl

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'))
66: AND TRUNC(TO_DATE(P_TO_DATE,'YYYY/MM/DD HH24:MI:SS'))

Line 118: zx_lines lines,

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,
121: zx_reporting_types_vl zrt
122: WHERE trx_lines.line_type ='LINE'