APPS.ZX_JL_EXTRACT_PKG dependencies on RA_CUSTOMER_TRX_LINES

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

8352: IF P_REPORT_NAME = 'JLARTPFF' THEN
8353:
8354: SELECT abs(sum(nvl(extended_amount,0) * nvl(p_exchange_rate_tbl(i),1)))
8355: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8356: FROM ra_customer_trx_lines
8357: WHERE customer_trx_id = p_trx_id_tbl(i);
8358:
8359: ELSIF P_REPORT_NAME = 'ZXCOARSB' THEN -- : Total Doc Amt.
8360:

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:

Line 8372: FROM RA_CUSTOMER_TRX_LINES L

8368: ELSIF P_REPORT_NAME = 'ZXZZTVSR' THEN
8369:
8370: SELECT (nvl(SUM(NVL(L.GROSS_EXTENDED_AMOUNT, nvl(L.EXTENDED_AMOUNT,0))),0) * p_exchange_rate_tbl(i))
8371: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8372: FROM RA_CUSTOMER_TRX_LINES L
8373: WHERE L.CUSTOMER_TRX_ID = p_trx_id_tbl(i);
8374:
8375: ELSIF P_REPORT_NAME in ('JLARTSFF','JLARTDFF') THEN
8376:

Line 8421: FROM ra_customer_trx_lines

8417: IF P_REPORT_NAME= 'JLARTDFF' THEN
8418:
8419: SELECT nvl(SUM(abs(NVL(GROSS_EXTENDED_AMOUNT, nvl(EXTENDED_AMOUNT,0)))),0)
8420: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8421: FROM ra_customer_trx_lines
8422: WHERE customer_trx_id = p_trx_id_tbl(i);
8423:
8424: ELSIF P_REPORT_NAME = 'JLARTSFF' THEN
8425:

Line 8434: FROM RA_CUSTOMER_TRX_LINES L

8430:
8431: SELECT (nvl(SUM(NVL(L.GROSS_EXTENDED_AMOUNT, nvl(L.EXTENDED_AMOUNT,0))),0)
8432: * nvl(p_exchange_rate_tbl(i),1))
8433: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8434: FROM RA_CUSTOMER_TRX_LINES L
8435: WHERE L.CUSTOMER_TRX_ID = p_trx_id_tbl(i);
8436: END IF;
8437:
8438: ELSE