APPS.ZX_JL_EXTRACT_PKG dependencies on RA_CUSTOMER_TRX_LINES

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 8832: FROM ra_customer_trx_lines

8828: IF P_REPORT_NAME = 'JLARTPFF' THEN
8829:
8830: SELECT abs(sum(nvl(extended_amount,0) * nvl(p_exchange_rate_tbl(i),1)))
8831: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8832: FROM ra_customer_trx_lines
8833: WHERE customer_trx_id = p_trx_id_tbl(i);
8834:
8835: ELSIF P_REPORT_NAME = 'ZXCOARSB' THEN -- : Total Doc Amt.
8836:

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:

Line 8848: FROM RA_CUSTOMER_TRX_LINES L

8844: ELSIF P_REPORT_NAME = 'ZXZZTVSR' THEN
8845:
8846: SELECT (nvl(SUM(NVL(L.GROSS_EXTENDED_AMOUNT, nvl(L.EXTENDED_AMOUNT,0))),0) * p_exchange_rate_tbl(i))
8847: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8848: FROM RA_CUSTOMER_TRX_LINES L
8849: WHERE L.CUSTOMER_TRX_ID = p_trx_id_tbl(i);
8850:
8851: ELSIF P_REPORT_NAME in ('JLARTSFF','JLZZTCFF','JLARTDFF') THEN
8852:

Line 8897: FROM ra_customer_trx_lines

8893: IF P_REPORT_NAME= 'JLARTDFF' THEN
8894:
8895: SELECT nvl(SUM(abs(NVL(GROSS_EXTENDED_AMOUNT, nvl(EXTENDED_AMOUNT,0)))),0)
8896: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8897: FROM ra_customer_trx_lines
8898: WHERE customer_trx_id = p_trx_id_tbl(i);
8899:
8900: ELSIF P_REPORT_NAME IN ('JLARTSFF','JLZZTCFF') THEN
8901:

Line 8910: FROM RA_CUSTOMER_TRX_LINES L

8906:
8907: SELECT (nvl(SUM(NVL(L.GROSS_EXTENDED_AMOUNT, nvl(L.EXTENDED_AMOUNT,0))),0)
8908: * nvl(p_exchange_rate_tbl(i),1))
8909: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8910: FROM RA_CUSTOMER_TRX_LINES L
8911: WHERE L.CUSTOMER_TRX_ID = p_trx_id_tbl(i);
8912: END IF;
8913:
8914: ELSE