APPS.ZX_JL_EXTRACT_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 4485: FROM ra_customer_trx_lines_all ctl

4481: SELECT (SUM(DECODE(ctl.line_type,'LINE', NVL(ctl.extended_amount,0),0))
4482: + SUM(DECODE(ctl.line_type,'FREIGHT',NVL(ctl.extended_amount,0),0))
4483: + SUM(DECODE(ctl.line_type,'CHARGE',NVL(ctl.extended_amount,0),0)))
4484: INTO l_taxable_amt_tbl(k)
4485: FROM ra_customer_trx_lines_all ctl
4486: WHERE ctl.customer_trx_line_id = p_trx_line_id(i)
4487: AND ctl.customer_trx_id = p_trx_id_tbl(i);
4488: END;
4489: X_TAXABLE_AMT_TBL(i):=l_taxable_amt_tbl(k);

Line 8841: FROM ra_customer_trx_lines_all ctl --Bug 5396444

8837: SELECT (SUM(DECODE(ctl.line_type,'LINE', NVL(ctl.extended_amount,0),0))
8838: + SUM(DECODE(ctl.line_type,'FREIGHT',NVL(ctl.extended_amount,0),0))
8839: + SUM(DECODE(ctl.line_type,'CHARGE',NVL(ctl.extended_amount,0),0)))-- * p_exchange_rate_tbl(i)
8840: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8841: FROM ra_customer_trx_lines_all ctl --Bug 5396444
8842: WHERE ctl.customer_trx_id = p_trx_id_tbl(i);
8843:
8844: ELSIF P_REPORT_NAME = 'ZXZZTVSR' THEN
8845: