[Home] [Help]
986: FROM
987: CST_SC_LOW_LEVEL_CODES csllc,
988: MTL_PARAMETERS mp,
989: CST_ITEM_COSTS cia,
990: BOM_OPERATIONAL_ROUTINGS bor,
991: BOM_OPERATION_SEQUENCES bos,
992: BOM_OPERATION_RESOURCES bomres,
993: BOM_RESOURCES br,
994: CST_RESOURCE_COSTS crc
1012: (alt_rtg_designator IS NOT NULL)
1013: AND (bor.ALTERNATE_ROUTING_DESIGNATOR IS NULL)
1014: AND NOT EXISTS
1015: (SELECT 'X'
1016: FROM BOM_OPERATIONAL_ROUTINGS bor1
1017: WHERE bor1.ASSEMBLY_ITEM_ID = bor.ASSEMBLY_ITEM_ID
1018: AND bor1.ORGANIZATION_ID = csllc.organization_id
1019: AND bor1.ALTERNATE_ROUTING_DESIGNATOR =
1020: alt_rtg_designator
1166: FROM
1167: CST_SC_LOW_LEVEL_CODES csllc,
1168: MTL_PARAMETERS mp,
1169: CST_ITEM_COSTS cia,
1170: BOM_OPERATIONAL_ROUTINGS bor,
1171: BOM_OPERATION_SEQUENCES bos,
1172: BOM_OPERATION_RESOURCES bomres,
1173: BOM_RESOURCES br
1174: WHERE csllc.rollup_id = l_rollup_id
1185: alt_rtg_designator IS NOT NULL
1186: AND (bor.alternate_routing_designator IS NULL)
1187: AND NOT EXISTS
1188: (SELECT 'X'
1189: FROM bom_operational_routings bor1
1190: WHERE bor1.assembly_item_id = bor.assembly_item_id
1191: AND bor1.organization_id = csllc.organization_id
1192: AND bor1.alternate_routing_designator = alt_rtg_designator
1193: AND ((l_mfg_flag = 1 AND bor1.routing_type = 1) OR (l_mfg_flag = 2))
1479: l_rollup_date, NULL)
1480: FROM
1481: CST_SC_LOW_LEVEL_CODES csllc,
1482: CST_ITEM_COSTS cia,
1483: BOM_OPERATIONAL_ROUTINGS bor,
1484: BOM_OPERATION_SEQUENCES bos,
1485: CST_DEPARTMENT_OVERHEADS cdo,
1486: MTL_PARAMETERS mp
1487: WHERE csllc.ROLLUP_ID = l_rollup_id
1506: AND (bor.ALTERNATE_ROUTING_DESIGNATOR IS NULL)
1507: AND NOT EXISTS
1508: (SELECT
1509: 'X'
1510: FROM BOM_OPERATIONAL_ROUTINGS bor1
1511: WHERE bor1.ASSEMBLY_ITEM_ID = bor.ASSEMBLY_ITEM_ID
1512: AND bor1.ORGANIZATION_ID = csllc.organization_id
1513: AND bor1.ALTERNATE_ROUTING_DESIGNATOR =
1514: alt_rtg_designator
2225: SET (OPERATION_SEQUENCE_ID,
2226: DEPARTMENT_ID) =
2227: (SELECT bos.OPERATION_SEQUENCE_ID,
2228: bos.DEPARTMENT_ID
2229: FROM BOM_OPERATIONAL_ROUTINGS bor,
2230: BOM_OPERATION_SEQUENCES bos
2231: WHERE bor.ASSEMBLY_ITEM_ID = cicd.INVENTORY_ITEM_ID
2232: AND bor.ORGANIZATION_ID = l_org_id_tbl(i)
2233: AND ((l_mfg_flag = 1 AND bor.ROUTING_TYPE = 1)
2240: OR(alt_rtg_designator IS NOT NULL
2241: AND (bor.ALTERNATE_ROUTING_DESIGNATOR IS NULL)
2242: AND NOT EXISTS
2243: (SELECT 'X'
2244: FROM BOM_OPERATIONAL_ROUTINGS bor1
2245: WHERE bor1.ASSEMBLY_ITEM_ID = bor.ASSEMBLY_ITEM_ID
2246: AND bor1.ORGANIZATION_ID = l_org_id_tbl(i)
2247: AND bor1.ALTERNATE_ROUTING_DESIGNATOR =alt_rtg_designator
2248: AND ((l_mfg_flag = 1 AND bor1.ROUTING_TYPE = 1)
2853: bos.operation_sequence_id OPERATION_SEQUENCE_ID,
2854: bos.operation_seq_num OPERATION_SEQ_NUM,
2855: ((1/NVL(bos.yield,1))-1) OPERATION_YIELD_FACTOR
2856: FROM bom_operation_sequences bos,
2857: bom_operational_routings bor,
2858: cst_sc_low_level_codes cllc
2859: WHERE cllc.rollup_id = l_rollup_id
2860: AND cllc.low_level_code = l_level
2861: AND bor.assembly_item_id = cllc.inventory_item_id
2868: (alt_rtg_designator IS NOT NULL)
2869: AND (bor.ALTERNATE_ROUTING_DESIGNATOR IS NULL)
2870: AND NOT EXISTS
2871: (SELECT 'X'
2872: FROM BOM_OPERATIONAL_ROUTINGS bor1
2873: WHERE bor1.ASSEMBLY_ITEM_ID = bor.assembly_item_id
2874: AND bor1.ORGANIZATION_ID = l_organization_id
2875: AND bor1.ALTERNATE_ROUTING_DESIGNATOR =
2876: alt_rtg_designator