APPS.JAI_AP_ST_REVERSE_PROCESS dependencies on RCV_SHIPMENT_LINES

Line 3419: , RCV_SHIPMENT_LINES RSL

3415: ,jcta.vat_flag vat_flag
3416: ,nvl(jcta.adhoc_flag,'N') adhoc_flag --12351311
3417: FROM
3418: JAI_RCV_LINE_TAXES jrl
3419: , RCV_SHIPMENT_LINES RSL
3420: , RCV_TRANSACTIONS RT
3421: , jai_cmn_taxes_all jcta
3422: WHERE jrl.shipment_line_id = rsl.shipment_line_id
3423: AND rt.shipment_line_id = rsl.shipment_line_id

Line 3465: , rcv_shipment_lines rsl

3461: ,jcta.vat_flag vat_flag
3462: ,nvl(jcta.adhoc_flag,'N') ADHOC_FLAG --12351311
3463: FROM
3464: jai_rcv_line_taxes jrl
3465: , rcv_shipment_lines rsl
3466: , rcv_transactions rt
3467: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
3468: WHERE jrl.shipment_line_id = rsl.shipment_line_id
3469: AND rt.shipment_line_id = rsl.shipment_line_id

Line 3501: , rcv_shipment_lines rsl

3497: ,jcta.vat_flag vat_flag
3498: ,nvl(jcta.adhoc_flag,'N') ADHOC_FLAG --12351311
3499: FROM
3500: jai_retro_tax_changes jrl
3501: , rcv_shipment_lines rsl
3502: , rcv_transactions rt
3503: , jai_retro_line_changes jrlc
3504: , jai_cmn_taxes_all jcta
3505: WHERE jrlc.doc_line_id = rsl.shipment_line_id

Line 5537: , rcv_shipment_lines rsl

5533: , jrl.tax_line_no
5534: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag
5535: FROM
5536: JAI_RCV_LINE_TAXES jrl
5537: , rcv_shipment_lines rsl
5538: , rcv_transactions rt
5539: , jai_cmn_taxes_all jcta
5540: WHERE jrl.shipment_line_id = rsl.shipment_line_id
5541: AND rt.shipment_line_id = rsl.shipment_line_id

Line 5654: shpmnt_ln_id rcv_shipment_lines.shipment_line_id%TYPE;

5650: v_dist_reversal_cnt NUMBER;
5651: v_batch_id NUMBER;
5652: c_tax_rec c_tax%ROWTYPE;
5653: v_source VARCHAR2(25);
5654: shpmnt_ln_id rcv_shipment_lines.shipment_line_id%TYPE;
5655: cur_items_rec cur_items%ROWTYPE;
5656: caid gl_sets_of_books.chart_of_accounts_id%TYPE;
5657: for_dist_insertion_rec for_dist_insertion%ROWTYPE;
5658: cum_tax_amt NUMBER := 0;