APPS.ZX_JL_EXTRACT_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 4346: FROM ra_customer_trx_lines_all ctl

4342: SELECT (SUM(DECODE(ctl.line_type,'LINE', NVL(ctl.extended_amount,0),0))
4343: + SUM(DECODE(ctl.line_type,'FREIGHT',NVL(ctl.extended_amount,0),0))
4344: + SUM(DECODE(ctl.line_type,'CHARGE',NVL(ctl.extended_amount,0),0))) --* p_exchange_rate_tbl(i)
4345: INTO l_taxable_amt_tbl(p_trx_line_id(i))
4346: FROM ra_customer_trx_lines_all ctl
4347: WHERE ctl.customer_trx_line_id = p_trx_line_id(i)
4348: AND ctl.customer_trx_id = p_trx_id_tbl(i);
4349:
4350: END;

Line 8365: FROM ra_customer_trx_lines_all ctl --Bug 5396444

8361: SELECT (SUM(DECODE(ctl.line_type,'LINE', NVL(ctl.extended_amount,0),0))
8362: + SUM(DECODE(ctl.line_type,'FREIGHT',NVL(ctl.extended_amount,0),0))
8363: + SUM(DECODE(ctl.line_type,'CHARGE',NVL(ctl.extended_amount,0),0)))-- * p_exchange_rate_tbl(i)
8364: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8365: FROM ra_customer_trx_lines_all ctl --Bug 5396444
8366: WHERE ctl.customer_trx_id = p_trx_id_tbl(i);
8367:
8368: ELSIF P_REPORT_NAME = 'ZXZZTVSR' THEN
8369: