eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RCV_TAX_PKG dependencies on RCV_SHIPMENT_LINES

Line 70: v_item_id rcv_shipment_lines.item_id % TYPE;

66: v_cor_quantity NUMBER;
67: v_rg_location_id JAI_INV_SUBINV_DTLS.location_id % TYPE;
68: v_po_header_date DATE;
69: v_vendor_site_id po_headers_all.vendor_site_id % TYPE;
70: v_item_id rcv_shipment_lines.item_id % TYPE;
71: v_organization_id rcv_shipment_lines.to_organization_id % TYPE;
72: v_item_modvat_flag JAI_INV_ITM_SETUPS.modvat_flag % TYPE;
73: v_item_trading_flag JAI_INV_ITM_SETUPS.item_trading_flag % TYPE;
74: v_receipt_source_code rcv_shipment_headers.receipt_source_code % TYPE;

Line 71: v_organization_id rcv_shipment_lines.to_organization_id % TYPE;

67: v_rg_location_id JAI_INV_SUBINV_DTLS.location_id % TYPE;
68: v_po_header_date DATE;
69: v_vendor_site_id po_headers_all.vendor_site_id % TYPE;
70: v_item_id rcv_shipment_lines.item_id % TYPE;
71: v_organization_id rcv_shipment_lines.to_organization_id % TYPE;
72: v_item_modvat_flag JAI_INV_ITM_SETUPS.modvat_flag % TYPE;
73: v_item_trading_flag JAI_INV_ITM_SETUPS.item_trading_flag % TYPE;
74: v_receipt_source_code rcv_shipment_headers.receipt_source_code % TYPE;
75: -- v_paddr v$session.paddr % TYPE;

Line 350: CURSOR c_rcv_shipment_lines(cp_shipment_line_id rcv_shipment_lines.shipment_line_id%TYPE)

346: */
347: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
348: -- End for bug 5243532
349: /*Bug 4644524 start bduvarag*/
350: CURSOR c_rcv_shipment_lines(cp_shipment_line_id rcv_shipment_lines.shipment_line_id%TYPE)
351: IS
352: SELECT item_id
353: FROM rcv_shipment_lines
354: WHERE shipment_line_id = cp_shipment_line_id;

Line 353: FROM rcv_shipment_lines

349: /*Bug 4644524 start bduvarag*/
350: CURSOR c_rcv_shipment_lines(cp_shipment_line_id rcv_shipment_lines.shipment_line_id%TYPE)
351: IS
352: SELECT item_id
353: FROM rcv_shipment_lines
354: WHERE shipment_line_id = cp_shipment_line_id;
355:
356: r_rcv_shipment_lines c_rcv_shipment_lines%ROWTYPE;
357: /*Bug 4644524 End bduvarag*/

Line 356: r_rcv_shipment_lines c_rcv_shipment_lines%ROWTYPE;

352: SELECT item_id
353: FROM rcv_shipment_lines
354: WHERE shipment_line_id = cp_shipment_line_id;
355:
356: r_rcv_shipment_lines c_rcv_shipment_lines%ROWTYPE;
357: /*Bug 4644524 End bduvarag*/
358:
359: -- For iSupp Porting
360: /*

Line 441: from rcv_shipment_lines

437: -- rchandan start - 6030615(INTERORG_XFER FP )
438:
439: Cursor c_rec_ship_txn(cp_ship_line_id IN NUMBER) is
440: select mmt_transaction_id
441: from rcv_shipment_lines
442: where shipment_line_id = cp_ship_line_id;
443:
444: r_rec_ship_txn c_rec_ship_txn%rowtype;
445:

Line 1783: FROM rcv_shipment_lines rsl

1779: THEN
1780:
1781: FOR excise_rec IN
1782: (SELECT rsl.shipment_header_id
1783: FROM rcv_shipment_lines rsl
1784: Where rsl.to_organization_id = p_organization_id
1785: and exists -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. rsl.po_header_id in
1786: (select pha.po_header_id
1787: from po_headers_all pha

Line 2282: OPEN c_rcv_shipment_lines(p_shipment_line_id);

2278: errormsg:='Error while fetching PO currency details :' || SQLERRM;
2279: RAISE_APPLICATION_ERROR (-20501, 'Error while fetching PO currency details :' || SQLERRM);
2280: END;
2281: /*Bug 4644524 start bduvarag*/
2282: OPEN c_rcv_shipment_lines(p_shipment_line_id);
2283: FETCH c_rcv_shipment_lines INTO r_rcv_shipment_lines;
2284: CLOSE c_rcv_shipment_lines;
2285: /*Bug 4644524 End bduvarag*/
2286:

Line 2283: FETCH c_rcv_shipment_lines INTO r_rcv_shipment_lines;

2279: RAISE_APPLICATION_ERROR (-20501, 'Error while fetching PO currency details :' || SQLERRM);
2280: END;
2281: /*Bug 4644524 start bduvarag*/
2282: OPEN c_rcv_shipment_lines(p_shipment_line_id);
2283: FETCH c_rcv_shipment_lines INTO r_rcv_shipment_lines;
2284: CLOSE c_rcv_shipment_lines;
2285: /*Bug 4644524 End bduvarag*/
2286:
2287: IF v_debug_flag = 'Y' THEN

Line 2284: CLOSE c_rcv_shipment_lines;

2280: END;
2281: /*Bug 4644524 start bduvarag*/
2282: OPEN c_rcv_shipment_lines(p_shipment_line_id);
2283: FETCH c_rcv_shipment_lines INTO r_rcv_shipment_lines;
2284: CLOSE c_rcv_shipment_lines;
2285: /*Bug 4644524 End bduvarag*/
2286:
2287: IF v_debug_flag = 'Y' THEN
2288: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_po_currency is ' || v_po_currency);

Line 2424: OPEN c_rcv_shipment_lines(p_shipment_line_id);

2420: open c_rec_ship_txn(p_shipment_line_id);
2421: fetch c_rec_ship_txn into r_rec_ship_txn;
2422: close c_rec_ship_txn;
2423:
2424: OPEN c_rcv_shipment_lines(p_shipment_line_id);
2425: FETCH c_rcv_shipment_lines INTO r_rcv_shipment_lines;
2426: CLOSE c_rcv_shipment_lines;
2427:
2428: OPEN c_get_inv_trx_info(r_rec_ship_txn.mmt_transaction_id);

Line 2425: FETCH c_rcv_shipment_lines INTO r_rcv_shipment_lines;

2421: fetch c_rec_ship_txn into r_rec_ship_txn;
2422: close c_rec_ship_txn;
2423:
2424: OPEN c_rcv_shipment_lines(p_shipment_line_id);
2425: FETCH c_rcv_shipment_lines INTO r_rcv_shipment_lines;
2426: CLOSE c_rcv_shipment_lines;
2427:
2428: OPEN c_get_inv_trx_info(r_rec_ship_txn.mmt_transaction_id);
2429: FETCH c_get_inv_trx_info INTO ln_trx_qty , lv_trx_uom , ln_orig_id , ln_item_cost;

Line 2426: CLOSE c_rcv_shipment_lines;

2422: close c_rec_ship_txn;
2423:
2424: OPEN c_rcv_shipment_lines(p_shipment_line_id);
2425: FETCH c_rcv_shipment_lines INTO r_rcv_shipment_lines;
2426: CLOSE c_rcv_shipment_lines;
2427:
2428: OPEN c_get_inv_trx_info(r_rec_ship_txn.mmt_transaction_id);
2429: FETCH c_get_inv_trx_info INTO ln_trx_qty , lv_trx_uom , ln_orig_id , ln_item_cost;
2430: CLOSE c_get_inv_trx_info;

Line 2818: ELSIF (lv_vat_recoverable_for_item <> jai_constants.yes OR r_rcv_shipment_lines.item_id IS NULL)

2814: v_tax_modvat_flag := 'N';
2815: /* following elsif added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
2816: /*Commented for Bug 4644524 bduvarag*/
2817: -- ELSIF lv_vat_recoverable_for_item <> jai_constants.yes
2818: ELSIF (lv_vat_recoverable_for_item <> jai_constants.yes OR r_rcv_shipment_lines.item_id IS NULL)
2819: AND po_lines_rec.regime_code = jai_constants.vat_regime
2820: THEN
2821: v_tax_modvat_flag := jai_constants.no;
2822:

Line 4207: and rownum <= (select line_num from rcv_shipment_lines where shipment_line_id = p_shipment_line_id) -- bug#3878439

4203: (select delivery_id from wsh_new_deliveries where name=rsh.shipment_num))
4204: and spl.order_line_id = sla.line_id
4205: and prla.requisition_line_id = p_requisition_line_id
4206: AND rsh.shipment_header_id = p_shipment_header_id
4207: and rownum <= (select line_num from rcv_shipment_lines where shipment_line_id = p_shipment_line_id) -- bug#3878439
4208: )
4209:
4210:
4211: LOOP