APPS.CSTPSCCR dependencies on BOM_OPERATIONAL_ROUTINGS

Line 989: BOM_OPERATIONAL_ROUTINGS bor,

985: FROM
986: CST_SC_LOW_LEVEL_CODES csllc,
987: MTL_PARAMETERS mp,
988: CST_ITEM_COSTS cia,
989: BOM_OPERATIONAL_ROUTINGS bor,
990: BOM_OPERATION_SEQUENCES bos,
991: BOM_OPERATION_RESOURCES bomres,
992: BOM_RESOURCES br,
993: CST_RESOURCE_COSTS crc

Line 1015: FROM BOM_OPERATIONAL_ROUTINGS bor1

1011: (alt_rtg_designator IS NOT NULL)
1012: AND (bor.ALTERNATE_ROUTING_DESIGNATOR IS NULL)
1013: AND NOT EXISTS
1014: (SELECT 'X'
1015: FROM BOM_OPERATIONAL_ROUTINGS bor1
1016: WHERE bor1.ASSEMBLY_ITEM_ID = bor.ASSEMBLY_ITEM_ID
1017: AND bor1.ORGANIZATION_ID = csllc.organization_id
1018: AND bor1.ALTERNATE_ROUTING_DESIGNATOR =
1019: alt_rtg_designator

Line 1169: BOM_OPERATIONAL_ROUTINGS bor,

1165: FROM
1166: CST_SC_LOW_LEVEL_CODES csllc,
1167: MTL_PARAMETERS mp,
1168: CST_ITEM_COSTS cia,
1169: BOM_OPERATIONAL_ROUTINGS bor,
1170: BOM_OPERATION_SEQUENCES bos,
1171: BOM_OPERATION_RESOURCES bomres,
1172: BOM_RESOURCES br
1173: WHERE csllc.rollup_id = l_rollup_id

Line 1188: FROM bom_operational_routings bor1

1184: alt_rtg_designator IS NOT NULL
1185: AND (bor.alternate_routing_designator IS NULL)
1186: AND NOT EXISTS
1187: (SELECT 'X'
1188: FROM bom_operational_routings bor1
1189: WHERE bor1.assembly_item_id = bor.assembly_item_id
1190: AND bor1.organization_id = csllc.organization_id
1191: AND bor1.alternate_routing_designator = alt_rtg_designator
1192: AND ((l_mfg_flag = 1 AND bor1.routing_type = 1) OR (l_mfg_flag = 2))

Line 1486: BOM_OPERATIONAL_ROUTINGS bor,

1482: l_rollup_date, NULL)
1483: FROM
1484: CST_SC_LOW_LEVEL_CODES csllc,
1485: CST_ITEM_COSTS cia,
1486: BOM_OPERATIONAL_ROUTINGS bor,
1487: BOM_OPERATION_SEQUENCES bos,
1488: CST_DEPARTMENT_OVERHEADS cdo,
1489: MTL_PARAMETERS mp
1490: WHERE csllc.ROLLUP_ID = l_rollup_id

Line 1513: FROM BOM_OPERATIONAL_ROUTINGS bor1

1509: AND (bor.ALTERNATE_ROUTING_DESIGNATOR IS NULL)
1510: AND NOT EXISTS
1511: (SELECT
1512: 'X'
1513: FROM BOM_OPERATIONAL_ROUTINGS bor1
1514: WHERE bor1.ASSEMBLY_ITEM_ID = bor.ASSEMBLY_ITEM_ID
1515: AND bor1.ORGANIZATION_ID = csllc.organization_id
1516: AND bor1.ALTERNATE_ROUTING_DESIGNATOR =
1517: alt_rtg_designator

Line 2230: FROM BOM_OPERATIONAL_ROUTINGS bor,

2226: SET (OPERATION_SEQUENCE_ID,
2227: DEPARTMENT_ID) =
2228: (SELECT bos.OPERATION_SEQUENCE_ID,
2229: bos.DEPARTMENT_ID
2230: FROM BOM_OPERATIONAL_ROUTINGS bor,
2231: BOM_OPERATION_SEQUENCES bos
2232: WHERE bor.ASSEMBLY_ITEM_ID = cicd.INVENTORY_ITEM_ID
2233: AND bor.ORGANIZATION_ID = l_org_id_tbl(i)
2234: AND ((l_mfg_flag = 1 AND bor.ROUTING_TYPE = 1)

Line 2245: FROM BOM_OPERATIONAL_ROUTINGS bor1

2241: OR(alt_rtg_designator IS NOT NULL
2242: AND (bor.ALTERNATE_ROUTING_DESIGNATOR IS NULL)
2243: AND NOT EXISTS
2244: (SELECT 'X'
2245: FROM BOM_OPERATIONAL_ROUTINGS bor1
2246: WHERE bor1.ASSEMBLY_ITEM_ID = bor.ASSEMBLY_ITEM_ID
2247: AND bor1.ORGANIZATION_ID = l_org_id_tbl(i)
2248: AND bor1.ALTERNATE_ROUTING_DESIGNATOR =alt_rtg_designator
2249: AND ((l_mfg_flag = 1 AND bor1.ROUTING_TYPE = 1)

Line 2858: bom_operational_routings bor,

2854: bos.operation_sequence_id OPERATION_SEQUENCE_ID,
2855: bos.operation_seq_num OPERATION_SEQ_NUM,
2856: ((1/NVL(bos.yield,1))-1) OPERATION_YIELD_FACTOR
2857: FROM bom_operation_sequences bos,
2858: bom_operational_routings bor,
2859: cst_sc_low_level_codes cllc
2860: WHERE cllc.rollup_id = l_rollup_id
2861: AND cllc.low_level_code = l_level
2862: AND bor.assembly_item_id = cllc.inventory_item_id

Line 2873: FROM BOM_OPERATIONAL_ROUTINGS bor1

2869: (alt_rtg_designator IS NOT NULL)
2870: AND (bor.ALTERNATE_ROUTING_DESIGNATOR IS NULL)
2871: AND NOT EXISTS
2872: (SELECT 'X'
2873: FROM BOM_OPERATIONAL_ROUTINGS bor1
2874: WHERE bor1.ASSEMBLY_ITEM_ID = bor.assembly_item_id
2875: AND bor1.ORGANIZATION_ID = l_organization_id
2876: AND bor1.ALTERNATE_ROUTING_DESIGNATOR =
2877: alt_rtg_designator