DBA Data[Home] [Help]

APPS.PO_CREATE_ISO dependencies on OE_HEADERS_IFACE_ALL

Line 43: Step 4: insert into oe_headers_iface_all from po_requisition_headers

39: as I.
40: Step 3: For every operating unit change, get the OPUNIT details.
41: If no detail found, set the transferred_to_oe_flag to 'E'
42: for those headers.
43: Step 4: insert into oe_headers_iface_all from po_requisition_headers
44: Step 5: For each row
45: insert into oe_lines_iface_all from po_requisition_lines
46: Step 6: Update the transferred_to_oe_flag to 'Y' for all 'I' ones and
47: to 'N' for all 'E' ones.

Line 314: INSERT INTO OE_HEADERS_IFACE_ALL

310: --Bug 7662103: The order_date_type_code needs to be populated 'ARRIVAL'
311: -- to enable planned IR to get synced wih the scheduled Arrival date in internal sales order
312:
313:
314: INSERT INTO OE_HEADERS_IFACE_ALL
315: (creation_date,
316: created_by,
317: last_update_date,
318: last_updated_by,