DBA Data[Home] [Help]

APPS.OE_UPG_SO_NEW dependencies on RCV_SHIPMENT_LINES

Line 2745: -- rcv_shipment_lines, rcv_transactions,rcv_supply

2741: begin
2742:
2743: IF v_return_lctr = 4 THEN
2744: -- Update PO Tables
2745: -- rcv_shipment_lines, rcv_transactions,rcv_supply
2746: update rcv_shipment_lines
2747: set oe_order_line_id = v_return_created_line_id
2748: where oe_order_line_id = g_old_line_id;
2749:

Line 2746: update rcv_shipment_lines

2742:
2743: IF v_return_lctr = 4 THEN
2744: -- Update PO Tables
2745: -- rcv_shipment_lines, rcv_transactions,rcv_supply
2746: update rcv_shipment_lines
2747: set oe_order_line_id = v_return_created_line_id
2748: where oe_order_line_id = g_old_line_id;
2749:
2750: update rcv_transactions

Line 8507: -- rcv_shipment_lines, rcv_transactions,rcv_supply

8503: END IF;
8504:
8505: begin
8506: -- Update PO Tables
8507: -- rcv_shipment_lines, rcv_transactions,rcv_supply
8508:
8509: select shipment_line_id
8510: into l_shipment_line_id
8511: from rcv_shipment_lines

Line 8511: from rcv_shipment_lines

8507: -- rcv_shipment_lines, rcv_transactions,rcv_supply
8508:
8509: select shipment_line_id
8510: into l_shipment_line_id
8511: from rcv_shipment_lines
8512: where oe_order_line_id = p_line_id
8513: and item_id = l_rec.inventory_item_id;
8514:
8515: update rcv_shipment_lines

Line 8515: update rcv_shipment_lines

8511: from rcv_shipment_lines
8512: where oe_order_line_id = p_line_id
8513: and item_id = l_rec.inventory_item_id;
8514:
8515: update rcv_shipment_lines
8516: set oe_order_line_id = l_line_id
8517: where shipment_line_id = l_shipment_line_id;
8518:
8519: update rcv_transactions