[Home] [Help]
284: --
285: OR (bom_item.bom_item_type = ITEM_TYPE_OPTION_CLASS
286: AND var_expl = SYS_YES))
287: AND comp.optional = SYS_NO
288: AND comp_item.bom_item_type = ITEM_TYPE_STANDARD)
289: OR (bom_item.base_item_id IS NOT NULL))
290: AND NVL(comp_item.ato_forecast_control, ATO_NONE) <> ATO_NONE
291: AND comp_item.inventory_item_id = comp.component_item_id
292: AND comp_item.organization_id = bom.organization_id
341: 'N');
342:
343: --
344: -- Insert the following into MRP_FORM_QUERY:
345: -- 1. Model and Option classes of mandatory standard items
346: -- which are inserted above
347: -- 2. Config items of those items inserted above
348: --
349: INSERT INTO mrp_form_query (
379: --
380: OR (bom_item.bom_item_type = ITEM_TYPE_OPTION_CLASS
381: AND var_expl = SYS_YES))
382: AND comp.optional = SYS_NO
383: AND comp_item.bom_item_type = ITEM_TYPE_STANDARD)
384: OR (bom_item.base_item_id IS NOT NULL))
385: AND bom_item.pick_components_flag = 'N'
386: AND bom_item.organization_id = bom.organization_id
387: AND bom_item.inventory_item_id = bom.assembly_item_id
584: 'CLASS',2,
585: 'CONFIG',4,
586: 'MODEL',1,
587: 'OPTION' ,3,
588: 'STANDARD',6,
589: -1),
590: 1, dem.inventory_item_id, NULL),
591: inv_salesorder.get_salesorder_for_oeheader(dem.HEADER_ID),
592: DECODE(dem.ITEM_TYPE_CODE,
593: 'CLASS',2,
594: 'CONFIG',4,
595: 'MODEL',1,
596: 'OPTION' ,3,
597: 'STANDARD',6,
598: -1),
599: dem.ato_line_id,
600: upd.rowid
601: FROM
703: 'CLASS',2,
704: 'CONFIG',4,
705: 'MODEL',1,
706: 'OPTION' ,3,
707: 'STANDARD',6,
708: -1),
709: 1, dem.inventory_item_id, NULL),
710: inv_salesorder.get_salesorder_for_oeheader(dem.HEADER_ID),
711: DECODE(dem.ITEM_TYPE_CODE,
712: 'CLASS',2,
713: 'CONFIG',4,
714: 'MODEL',1,
715: 'OPTION' ,3,
716: 'STANDARD',6,
717: -1),
718: dem.ato_line_id,
719: upd.rowid
720: FROM