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 250: INSERT INTO OE_HEADERS_IFACE_ALL

246: --Bug 7662103: The order_date_type_code needs to be populated 'ARRIVAL'
247: -- to enable planned IR to get synced wih the scheduled Arrival date in internal sales order
248:
249:
250: INSERT INTO OE_HEADERS_IFACE_ALL
251: (creation_date,
252: created_by,
253: last_update_date,
254: last_updated_by,