eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPSCCR dependencies on BOM_OPERATION_SEQUENCES

Line 991: BOM_OPERATION_SEQUENCES bos,

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
995: WHERE csllc.ROLLUP_ID = l_rollup_id

Line 1054: from bom_operation_sequences bos2

1050: unimp_flag = 1 AND
1051: bos.effectivity_date =
1052: (
1053: select max( bos2.effectivity_date )
1054: from bom_operation_sequences bos2
1055: where bos2.routing_sequence_id = bos.routing_sequence_id
1056: and NVL( bos2.operation_type, 1 ) = NVL( bos.operation_type, 1 )
1057: and bos2.operation_seq_num = bos.operation_seq_num
1058:

Line 1171: BOM_OPERATION_SEQUENCES bos,

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
1175: AND cia.inventory_item_id = csllc.inventory_item_id

Line 1213: FROM bom_operation_sequences bos2

1209: OR
1210: (unimp_flag = 1 AND bos.effectivity_date =
1211: (
1212: SELECT MAX( bos2.effectivity_date )
1213: FROM bom_operation_sequences bos2
1214: WHERE bos2.routing_sequence_id = bos.routing_sequence_id
1215: AND NVL( bos2.operation_type, 1 ) = NVL( bos.operation_type, 1 )
1216: AND bos2.operation_seq_num = bos.operation_seq_num
1217:

Line 1484: BOM_OPERATION_SEQUENCES bos,

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
1488: AND cia.BASED_ON_ROLLUP_FLAG (+) = 1 /* YES */

Line 1548: from bom_operation_sequences bos2

1544: unimp_flag = 1 AND
1545: bos.effectivity_date =
1546: (
1547: select max( bos2.effectivity_date )
1548: from bom_operation_sequences bos2
1549: where bos2.routing_sequence_id = bos.routing_sequence_id
1550: and NVL( bos2.operation_type, 1 ) = NVL( bos.operation_type, 1 )
1551: and bos2.operation_seq_num = bos.operation_seq_num
1552:

Line 2230: BOM_OPERATION_SEQUENCES bos

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)
2234: OR

Line 2276: FROM bom_operation_sequences bos2

2272: OR
2273: ( unimp_flag = 1
2274: AND bos.effectivity_date =
2275: (SELECT MAX(bos2.effectivity_date )
2276: FROM bom_operation_sequences bos2
2277: WHERE bos2.routing_sequence_id = bos.routing_sequence_id
2278: AND NVL(bos2.operation_type, 1) = NVL(bos.operation_type, 1)
2279: AND bos2.operation_seq_num = bos.operation_seq_num
2280:

Line 2856: FROM bom_operation_sequences bos,

2852: bos.department_id DEPARTMENT_ID,
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