[Home] [Help]
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.
48: Step 7: return
49: ==============================================================================*/
440: but the unit price was destination org's currency unit price as the conversion took place
441: already. This was a mismatch when the Sales Order was created. Hence we revert the
442: unit price to the cost price of source org, before we populate the interface table.
443: Hence added a new function get_cst_price and this is called while inserting the unit_price
444: columns in so_oe_lines_iface_all table */
445:
446: /* 1906141 -Subinventory was not populated in oe_lines_iface_all.
447: Populating the source subinventory from requisition lines */
448:
442: unit price to the cost price of source org, before we populate the interface table.
443: Hence added a new function get_cst_price and this is called while inserting the unit_price
444: columns in so_oe_lines_iface_all table */
445:
446: /* 1906141 -Subinventory was not populated in oe_lines_iface_all.
447: Populating the source subinventory from requisition lines */
448:
449: /* Bug 1988404 - Removed the insert of value to schedule_ship_date. If this is
450: populated, when Order Import calls Scheduling that fails if the on hand inventory
475: l_ext_precision,
476: l_min_unit);
477: /*rounding the value of the unit_selling_price
478: and unit_list_price to extended precision while inserting data into
479: oe_lines_iface_all*/
480:
481: --end bug 3249134
482:
483: --
521: As a workaround we are just popuating the same Customer
522: information as the header for the all the sales Order
523: lines for the same OU to by pass OM Validation. */
524:
525: INSERT INTO OE_LINES_IFACE_ALL
526: (CREATION_DATE,
527: CREATED_BY,
528: LAST_UPDATE_DATE,
529: LAST_UPDATED_BY,