[Home] [Help]
1148: TOTAL_PRODUCT_CYCLE_TIME,
1149: CTP_FLAG
1150: )
1151: select
1152: BOM_OPERATIONAL_ROUTINGS_S.NEXTVAL,
1153: m.inventory_item_id,
1154: m.organization_id,
1155: NULL,
1156: SYSDATE,
1195: b.cfm_routing_flag,
1196: b.total_product_cycle_time,
1197: b.ctp_flag
1198: from
1199: BOM_OPERATIONAL_ROUTINGS b,
1200: MTL_DEMAND d,
1201: MTL_PARAMETERS mp,
1202: MTL_SYSTEM_ITEMS_INTERFACE m
1203: where m.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1234:
1235: Update BOM_OP_ROUTINGS_INTERFACE b
1236: set mixed_model_map_flag =
1237: ( select 1
1238: from bom_operational_routings b1,
1239: mtl_system_items_interface m
1240: where b.assembly_item_id = m.inventory_item_id
1241: and b.organization_id = m.organization_id
1242: and m.set_id = to_char(to_number(USERENV('SESSIONID')))
1380: bom_op_routings_interface b1,
1381: mtl_demand d2,/* Model for est. release date */
1382: mtl_demand d1,
1383: mtl_system_items si1,
1384: bom_operational_routings or1,
1385: bom_operation_sequences os1
1386: where b1.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1387: and d1.rto_model_source_line = b1.demand_source_line
1388: and d1.config_status = 20
1535: bom_op_routings_interface b1,
1536: mtl_demand d2,/* Model for est. release date */
1537: mtl_demand d1,
1538: mtl_system_items si1,
1539: bom_operational_routings or1,
1540: bom_operation_sequences os1
1541: where b1.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1542: and d1.rto_model_source_line = b1.demand_source_line
1543: and d1.config_status = 20
1693: mtl_demand d2, /* parents */
1694: mtl_demand d3, /* Model estd release date */
1695: bom_inventory_components ic1,
1696: bom_bill_of_materials b1,
1697: bom_operational_routings or1,
1698: bom_operation_sequences os1
1699: where b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1700: and d1.rto_model_source_line = b.demand_source_line
1701: and d1.demand_type in (2,3) /* option class,option item */
1868: total_time_user,
1869: Net_planning_percent
1870: from
1871: bom_operation_sequences os1,
1872: bom_operational_routings or1,
1873: mtl_system_items si2,
1874: bom_inventory_components ic1,
1875: bom_bill_of_materials b1,
1876: mtl_system_items si1,
2011: s.operation_seq_num
2012: from
2013: mtl_demand md,
2014: mtl_system_items ms,
2015: bom_operational_routings r,
2016: bom_operation_sequences s,
2017: bom_op_routings_interface ri
2018: where ri.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
2019: and ri.routing_sequence_id = si.routing_sequence_id