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.WMS_PARAMETER_PVT dependencies on RCV_TRANSACTIONS

Line 5378: CURSOR l_rcv_transactions_curs IS

5374: FROM rcv_shipment_lines
5375: WHERE shipment_line_id=p_reference_id;
5376: --bug13949783
5377:
5378: CURSOR l_rcv_transactions_curs IS
5379: SELECT po_header_id
5380: , po_line_id
5381: FROM rcv_transactions
5382: WHERE transaction_id = p_reference_id;

Line 5381: FROM rcv_transactions

5377:
5378: CURSOR l_rcv_transactions_curs IS
5379: SELECT po_header_id
5380: , po_line_id
5381: FROM rcv_transactions
5382: WHERE transaction_id = p_reference_id;
5383: BEGIN
5384: IF inv_pp_debug.is_debug_mode THEN
5385: inv_pp_debug.send_message_to_pipe('GetPOHeaderLineID(): ');

Line 5426: inv_pp_debug.send_message_to_pipe('Open cursor rcv_transactions ');

5422: ELSIF (p_transaction_source_type_id = 1
5423: AND p_reference_id IS NOT NULL
5424: ) THEN
5425: IF inv_pp_debug.is_debug_mode THEN
5426: inv_pp_debug.send_message_to_pipe('Open cursor rcv_transactions ');
5427: END IF;
5428:
5429: OPEN l_rcv_transactions_curs;
5430: FETCH l_rcv_transactions_curs INTO l_po_header_id, l_po_line_id;

Line 5429: OPEN l_rcv_transactions_curs;

5425: IF inv_pp_debug.is_debug_mode THEN
5426: inv_pp_debug.send_message_to_pipe('Open cursor rcv_transactions ');
5427: END IF;
5428:
5429: OPEN l_rcv_transactions_curs;
5430: FETCH l_rcv_transactions_curs INTO l_po_header_id, l_po_line_id;
5431: CLOSE l_rcv_transactions_curs;
5432:
5433: IF inv_pp_debug.is_debug_mode THEN

Line 5430: FETCH l_rcv_transactions_curs INTO l_po_header_id, l_po_line_id;

5426: inv_pp_debug.send_message_to_pipe('Open cursor rcv_transactions ');
5427: END IF;
5428:
5429: OPEN l_rcv_transactions_curs;
5430: FETCH l_rcv_transactions_curs INTO l_po_header_id, l_po_line_id;
5431: CLOSE l_rcv_transactions_curs;
5432:
5433: IF inv_pp_debug.is_debug_mode THEN
5434: inv_pp_debug.send_message_to_pipe('l_po_header_id : '|| l_po_header_id);

Line 5431: CLOSE l_rcv_transactions_curs;

5427: END IF;
5428:
5429: OPEN l_rcv_transactions_curs;
5430: FETCH l_rcv_transactions_curs INTO l_po_header_id, l_po_line_id;
5431: CLOSE l_rcv_transactions_curs;
5432:
5433: IF inv_pp_debug.is_debug_mode THEN
5434: inv_pp_debug.send_message_to_pipe('l_po_header_id : '|| l_po_header_id);
5435: inv_pp_debug.send_message_to_pipe('l_po_line_id : '|| l_po_line_id);

Line 5917: FROM rcv_transactions

5913: --Begin bug 4505225
5914: CURSOR l_oe_rcv_curs IS
5915: SELECT oe_order_header_id
5916: , oe_order_line_id
5917: FROM rcv_transactions
5918: WHERE transaction_id = p_reference_id
5919: AND routing_header_id = 3 ;
5920: --End bug 4505225
5921: BEGIN