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 5370: CURSOR l_rcv_transactions_curs IS

5366: , po_line_id
5367: FROM po_line_locations_all
5368: WHERE line_location_id = p_reference_id;
5369:
5370: CURSOR l_rcv_transactions_curs IS
5371: SELECT po_header_id
5372: , po_line_id
5373: FROM rcv_transactions
5374: WHERE transaction_id = p_reference_id;

Line 5373: FROM rcv_transactions

5369:
5370: CURSOR l_rcv_transactions_curs IS
5371: SELECT po_header_id
5372: , po_line_id
5373: FROM rcv_transactions
5374: WHERE transaction_id = p_reference_id;
5375: BEGIN
5376: IF inv_pp_debug.is_debug_mode THEN
5377: inv_pp_debug.send_message_to_pipe('GetPOHeaderLineID(): ');

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

5408: ELSIF (p_transaction_source_type_id = 1
5409: AND p_reference_id IS NOT NULL
5410: ) THEN
5411: IF inv_pp_debug.is_debug_mode THEN
5412: inv_pp_debug.send_message_to_pipe('Open cursor rcv_transactions ');
5413: END IF;
5414:
5415: OPEN l_rcv_transactions_curs;
5416: FETCH l_rcv_transactions_curs INTO l_po_header_id, l_po_line_id;

Line 5415: OPEN l_rcv_transactions_curs;

5411: IF inv_pp_debug.is_debug_mode THEN
5412: inv_pp_debug.send_message_to_pipe('Open cursor rcv_transactions ');
5413: END IF;
5414:
5415: OPEN l_rcv_transactions_curs;
5416: FETCH l_rcv_transactions_curs INTO l_po_header_id, l_po_line_id;
5417: CLOSE l_rcv_transactions_curs;
5418:
5419: IF inv_pp_debug.is_debug_mode THEN

Line 5416: FETCH l_rcv_transactions_curs INTO l_po_header_id, l_po_line_id;

5412: inv_pp_debug.send_message_to_pipe('Open cursor rcv_transactions ');
5413: END IF;
5414:
5415: OPEN l_rcv_transactions_curs;
5416: FETCH l_rcv_transactions_curs INTO l_po_header_id, l_po_line_id;
5417: CLOSE l_rcv_transactions_curs;
5418:
5419: IF inv_pp_debug.is_debug_mode THEN
5420: inv_pp_debug.send_message_to_pipe('l_po_header_id : '|| l_po_header_id);

Line 5417: CLOSE l_rcv_transactions_curs;

5413: END IF;
5414:
5415: OPEN l_rcv_transactions_curs;
5416: FETCH l_rcv_transactions_curs INTO l_po_header_id, l_po_line_id;
5417: CLOSE l_rcv_transactions_curs;
5418:
5419: IF inv_pp_debug.is_debug_mode THEN
5420: inv_pp_debug.send_message_to_pipe('l_po_header_id : '|| l_po_header_id);
5421: inv_pp_debug.send_message_to_pipe('l_po_line_id : '|| l_po_line_id);

Line 5903: FROM rcv_transactions

5899: --Begin bug 4505225
5900: CURSOR l_oe_rcv_curs IS
5901: SELECT oe_order_header_id
5902: , oe_order_line_id
5903: FROM rcv_transactions
5904: WHERE transaction_id = p_reference_id
5905: AND routing_header_id = 3 ;
5906: --End bug 4505225
5907: BEGIN