[Home] [Help]
204: b1.routing_sequence_id,
205: b1.last_update_login
206: from BOM_OP_SEQUENCES_INTERFACE b1,
207: BOM_OP_SEQUENCES_INTERFACE b2,
208: BOM_OP_ROUTINGS_INTERFACE r2
209: where r2.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
210: and b2.routing_sequence_id = r2.routing_sequence_id
211: and b1.routing_sequence_id = b2.routing_sequence_id
212: and b1.operation_sequence_id <> b2.operation_sequence_id
1096:
1097: /*
1098: ** Load routing header interface table
1099: */
1100: table_name := 'BOM_OP_ROUTINGS_INTERFACE';
1101: stmt_num := 110;
1102: insert into BOM_OP_ROUTINGS_INTERFACE
1103: (
1104: ROUTING_SEQUENCE_ID,
1098: ** Load routing header interface table
1099: */
1100: table_name := 'BOM_OP_ROUTINGS_INTERFACE';
1101: stmt_num := 110;
1102: insert into BOM_OP_ROUTINGS_INTERFACE
1103: (
1104: ROUTING_SEQUENCE_ID,
1105: ASSEMBLY_ITEM_ID,
1106: ORGANIZATION_ID,
1213: and mp.organization_id = m.organization_id;
1214:
1215: /*
1216: ** Update the common_routing_sequence_id equal to the
1217: ** routing_sequence_id in BOM_OP_ROUTINGS_INTERFACE
1218: */
1219:
1220: stmt_num := 120;
1221: update BOM_OP_ROUTINGS_INTERFACE b
1217: ** routing_sequence_id in BOM_OP_ROUTINGS_INTERFACE
1218: */
1219:
1220: stmt_num := 120;
1221: update BOM_OP_ROUTINGS_INTERFACE b
1222: set common_routing_sequence_id = routing_sequence_id
1223: where (b.common_routing_sequence_id =1 or
1224: b.common_routing_sequence_id is NULL )
1225: and b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1231: ** equal to 1. */
1232:
1233: stmt_num := 125;
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
1376: machine_time_user,
1377: total_time_user,
1378: Net_planning_percent
1379: from
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,
1531: machine_time_user,
1532: total_time_user,
1533: Net_planning_percent
1534: from
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,
1687: machine_time_user,
1688: total_time_user,
1689: Net_planning_percent
1690: from
1691: bom_op_routings_interface b,
1692: mtl_demand d1, /* components */
1693: mtl_demand d2, /* parents */
1694: mtl_demand d3, /* Model estd release date */
1695: bom_inventory_components ic1,
1875: bom_bill_of_materials b1,
1876: mtl_system_items si1,
1877: mtl_demand d2, /* Model if option class */
1878: mtl_demand d1, /* Model or option class */
1879: bom_op_routings_interface b
1880: where b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1881: and d1.rto_model_source_line = b.demand_source_line
1882: and d1.config_status = 20
1883: and d1.component_sequence_id is not NULL
1966: update bom_op_sequences_interface bos1
1967: set process_op_seq_id = (
1968: select operation_sequence_id
1969: from bom_op_sequences_interface bos2,
1970: bom_op_routings_interface b
1971: where bos1.process_op_seq_id = bos2.model_op_seq_id
1972: and bos1.routing_sequence_id = b.routing_sequence_id
1973: and bos1.routing_sequence_id = bos2.routing_sequence_id
1974: and b.set_id = to_char(to_number(USERENV('SESSIONID'))))
1977: update bom_op_sequences_interface bos1
1978: set line_op_seq_id = (
1979: select operation_sequence_id
1980: from bom_op_sequences_interface bos2,
1981: bom_op_routings_interface b
1982: where bos1.line_op_seq_id = bos2.model_op_seq_id
1983: and bos1.routing_sequence_id = b.routing_sequence_id
1984: and bos1.routing_sequence_id = bos2.routing_sequence_id
1985: and b.set_id = to_char(to_number(USERENV('SESSIONID'))))
1990: ** there is no operation associated with the routing
1991: */
1992:
1993: stmt_num := 170;
1994: table_name := 'BOM_OP_ROUTINGS_INTERFACE';
1995:
1996: delete from BOM_OP_ROUTINGS_INTERFACE b1
1997: where b1.routing_sequence_id not in
1998: (select b2.routing_sequence_id
1992:
1993: stmt_num := 170;
1994: table_name := 'BOM_OP_ROUTINGS_INTERFACE';
1995:
1996: delete from BOM_OP_ROUTINGS_INTERFACE b1
1997: where b1.routing_sequence_id not in
1998: (select b2.routing_sequence_id
1999: from BOM_OP_SEQUENCES_INTERFACE b2
2000: where b2.routing_sequence_id = b1.routing_sequence_id)
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
2020: and md.rto_model_source_line = ri.demand_source_line
2021: and md.config_status = 20
2045: where not exists
2046: (select 'op seq exists in config routing'
2047: from
2048: BOM_OP_SEQUENCES_INTERFACE oi,
2049: BOM_OP_ROUTINGS_INTERFACE ri,
2050: BOM_BILL_OF_MTLS_INTERFACE bi
2051: where ci.bill_sequence_id = bi.bill_sequence_id
2052: and oi.operation_seq_num = ci.operation_seq_num
2053: and oi.routing_sequence_id = ri.routing_sequence_id
2234: NULL /* program_update_date */
2235: from
2236: bom_op_sequences_interface osi,
2237: bom_operation_resources bor,
2238: bom_op_routings_interface b
2239: where
2240: osi.routing_sequence_id = b.routing_sequence_id
2241: and b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
2242: and osi.model_op_seq_id = bor.operation_sequence_id;