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 328: CURSOR c_rcv_shipment_lines(cp_shipment_line_id rcv_shipment_lines.shipment_line_id%TYPE)

324: */
325: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
326: -- End for bug 5243532
327: /*Bug 4644524 start bduvarag*/
328: CURSOR c_rcv_shipment_lines(cp_shipment_line_id rcv_shipment_lines.shipment_line_id%TYPE)
329: IS
330: SELECT item_id
331: FROM rcv_shipment_lines
332: WHERE shipment_line_id = cp_shipment_line_id;

Line 331: FROM rcv_shipment_lines

327: /*Bug 4644524 start bduvarag*/
328: CURSOR c_rcv_shipment_lines(cp_shipment_line_id rcv_shipment_lines.shipment_line_id%TYPE)
329: IS
330: SELECT item_id
331: FROM rcv_shipment_lines
332: WHERE shipment_line_id = cp_shipment_line_id;
333:
334: r_rcv_shipment_lines c_rcv_shipment_lines%ROWTYPE;
335: /*Bug 4644524 End bduvarag*/

Line 334: r_rcv_shipment_lines c_rcv_shipment_lines%ROWTYPE;

330: SELECT item_id
331: FROM rcv_shipment_lines
332: WHERE shipment_line_id = cp_shipment_line_id;
333:
334: r_rcv_shipment_lines c_rcv_shipment_lines%ROWTYPE;
335: /*Bug 4644524 End bduvarag*/
336:
337: -- For iSupp Porting
338: /*

Line 419: from rcv_shipment_lines

415: -- rchandan start - 6030615(INTERORG_XFER FP )
416:
417: Cursor c_rec_ship_txn(cp_ship_line_id IN NUMBER) is
418: select mmt_transaction_id
419: from rcv_shipment_lines
420: where shipment_line_id = cp_ship_line_id;
421:
422: r_rec_ship_txn c_rec_ship_txn%rowtype;
423:

Line 1567: FROM rcv_shipment_lines rsl

1563: THEN
1564:
1565: FOR excise_rec IN
1566: (SELECT rsl.shipment_header_id
1567: FROM rcv_shipment_lines rsl
1568: Where rsl.to_organization_id = p_organization_id
1569: and exists -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. rsl.po_header_id in
1570: (select pha.po_header_id
1571: from po_headers_all pha

Line 2036: OPEN c_rcv_shipment_lines(p_shipment_line_id);

2032: errormsg:='Error while fetching PO currency details :' || SQLERRM;
2033: RAISE_APPLICATION_ERROR (-20501, 'Error while fetching PO currency details :' || SQLERRM);
2034: END;
2035: /*Bug 4644524 start bduvarag*/
2036: OPEN c_rcv_shipment_lines(p_shipment_line_id);
2037: FETCH c_rcv_shipment_lines INTO r_rcv_shipment_lines;
2038: CLOSE c_rcv_shipment_lines;
2039: /*Bug 4644524 End bduvarag*/
2040:

Line 2037: FETCH c_rcv_shipment_lines INTO r_rcv_shipment_lines;

2033: RAISE_APPLICATION_ERROR (-20501, 'Error while fetching PO currency details :' || SQLERRM);
2034: END;
2035: /*Bug 4644524 start bduvarag*/
2036: OPEN c_rcv_shipment_lines(p_shipment_line_id);
2037: FETCH c_rcv_shipment_lines INTO r_rcv_shipment_lines;
2038: CLOSE c_rcv_shipment_lines;
2039: /*Bug 4644524 End bduvarag*/
2040:
2041: IF v_debug_flag = 'Y' THEN

Line 2038: CLOSE c_rcv_shipment_lines;

2034: END;
2035: /*Bug 4644524 start bduvarag*/
2036: OPEN c_rcv_shipment_lines(p_shipment_line_id);
2037: FETCH c_rcv_shipment_lines INTO r_rcv_shipment_lines;
2038: CLOSE c_rcv_shipment_lines;
2039: /*Bug 4644524 End bduvarag*/
2040:
2041: IF v_debug_flag = 'Y' THEN
2042: UTL_FILE.PUT_LINE(v_myfilehandle,'The Value of v_po_currency is ' || v_po_currency);

Line 2170: OPEN c_rcv_shipment_lines(p_shipment_line_id);

2166: open c_rec_ship_txn(p_shipment_line_id);
2167: fetch c_rec_ship_txn into r_rec_ship_txn;
2168: close c_rec_ship_txn;
2169:
2170: OPEN c_rcv_shipment_lines(p_shipment_line_id);
2171: FETCH c_rcv_shipment_lines INTO r_rcv_shipment_lines;
2172: CLOSE c_rcv_shipment_lines;
2173:
2174: OPEN c_get_inv_trx_info(r_rec_ship_txn.mmt_transaction_id);

Line 2171: FETCH c_rcv_shipment_lines INTO r_rcv_shipment_lines;

2167: fetch c_rec_ship_txn into r_rec_ship_txn;
2168: close c_rec_ship_txn;
2169:
2170: OPEN c_rcv_shipment_lines(p_shipment_line_id);
2171: FETCH c_rcv_shipment_lines INTO r_rcv_shipment_lines;
2172: CLOSE c_rcv_shipment_lines;
2173:
2174: OPEN c_get_inv_trx_info(r_rec_ship_txn.mmt_transaction_id);
2175: FETCH c_get_inv_trx_info INTO ln_trx_qty , lv_trx_uom , ln_orig_id , ln_item_cost;

Line 2172: CLOSE c_rcv_shipment_lines;

2168: close c_rec_ship_txn;
2169:
2170: OPEN c_rcv_shipment_lines(p_shipment_line_id);
2171: FETCH c_rcv_shipment_lines INTO r_rcv_shipment_lines;
2172: CLOSE c_rcv_shipment_lines;
2173:
2174: OPEN c_get_inv_trx_info(r_rec_ship_txn.mmt_transaction_id);
2175: FETCH c_get_inv_trx_info INTO ln_trx_qty , lv_trx_uom , ln_orig_id , ln_item_cost;
2176: CLOSE c_get_inv_trx_info;

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

2383: v_tax_modvat_flag := 'N';
2384: /* following elsif added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
2385: /*Commented for Bug 4644524 bduvarag*/
2386: -- ELSIF lv_vat_recoverable_for_item <> jai_constants.yes
2387: ELSIF (lv_vat_recoverable_for_item <> jai_constants.yes OR r_rcv_shipment_lines.item_id IS NULL)
2388: AND po_lines_rec.regime_code = jai_constants.vat_regime
2389: THEN
2390: v_tax_modvat_flag := jai_constants.no;
2391:

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

3069: (select delivery_id from wsh_new_deliveries where name=rsh.shipment_num))
3070: and spl.order_line_id = sla.line_id
3071: and prla.requisition_line_id = p_requisition_line_id
3072: AND rsh.shipment_header_id = p_shipment_header_id
3073: and rownum <= (select line_num from rcv_shipment_lines where shipment_line_id = p_shipment_line_id) -- bug#3878439
3074: )
3075:
3076:
3077: LOOP