DBA Data[Home] [Help]

APPS.OE_UPG_SO dependencies on RCV_SHIPMENT_LINES

Line 2127: -- rcv_shipment_lines, rcv_transactions,rcv_supply

2123: begin
2124:
2125: IF v_return_lctr = 4 THEN
2126: -- Update PO Tables
2127: -- rcv_shipment_lines, rcv_transactions,rcv_supply
2128: update rcv_shipment_lines
2129: set oe_order_line_id = v_return_created_line_id
2130: where oe_order_line_id = g_old_line_id;
2131:

Line 2128: update rcv_shipment_lines

2124:
2125: IF v_return_lctr = 4 THEN
2126: -- Update PO Tables
2127: -- rcv_shipment_lines, rcv_transactions,rcv_supply
2128: update rcv_shipment_lines
2129: set oe_order_line_id = v_return_created_line_id
2130: where oe_order_line_id = g_old_line_id;
2131:
2132: update rcv_transactions

Line 6210: -- rcv_shipment_lines, rcv_transactions,rcv_supply

6206: END IF;
6207:
6208: begin
6209: -- Update PO Tables
6210: -- rcv_shipment_lines, rcv_transactions,rcv_supply
6211:
6212: select shipment_line_id
6213: into l_shipment_line_id
6214: from rcv_shipment_lines

Line 6214: from rcv_shipment_lines

6210: -- rcv_shipment_lines, rcv_transactions,rcv_supply
6211:
6212: select shipment_line_id
6213: into l_shipment_line_id
6214: from rcv_shipment_lines
6215: where oe_order_line_id = p_line_id
6216: and item_id = l_rec.inventory_item_id;
6217:
6218: update rcv_shipment_lines

Line 6218: update rcv_shipment_lines

6214: from rcv_shipment_lines
6215: where oe_order_line_id = p_line_id
6216: and item_id = l_rec.inventory_item_id;
6217:
6218: update rcv_shipment_lines
6219: set oe_order_line_id = l_line_id
6220: where shipment_line_id = l_shipment_line_id;
6221:
6222: update rcv_transactions