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 990: BOM_OPERATION_SEQUENCES bos,

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

Line 1053: from bom_operation_sequences bos2

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

Line 1170: BOM_OPERATION_SEQUENCES bos,

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

Line 1212: FROM bom_operation_sequences bos2

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

Line 1487: BOM_OPERATION_SEQUENCES bos,

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

Line 1551: from bom_operation_sequences bos2

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

Line 2231: BOM_OPERATION_SEQUENCES bos

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

Line 2277: FROM bom_operation_sequences bos2

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

Line 2857: FROM bom_operation_sequences bos,

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