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.CSTPACWC dependencies on BOM_RESOURCES

Line 520: bom_resources br

516: AND w.organization_id = i_org_id
517: AND EXISTS
518: (SELECT null
519: FROM wip_operation_resources wor,
520: bom_resources br
521: WHERE wor.wip_entity_id = i_wip_entity_id
522: AND wor.organization_id = i_org_id
523: AND wor.organization_id = br.organization_id
524: AND wor.resource_id = br.resource_id

Line 528: bom_resources br3

524: AND wor.resource_id = br.resource_id
525: AND EXISTS
526: (SELECT null
527: FROM wip_operation_resources w3,
528: bom_resources br3
529: WHERE w3.wip_entity_id = i_wip_entity_id
530: AND w3.organization_id = i_org_id
531: AND w3.resource_seq_num = w.resource_seq_num
532: AND w3.operation_seq_num = w.operation_seq_num

Line 586: bom_resources br

582: AND w.organization_id = i_org_id
583: AND EXISTS
584: (SELECT null
585: FROM wip_operation_resources wor,
586: bom_resources br
587: WHERE wor.wip_entity_id = i_wip_entity_id
588: AND wor.organization_id = i_org_id
589: AND wor.organization_id = br.organization_id
590: AND wor.resource_id = br.resource_id

Line 594: bom_resources br3

590: AND wor.resource_id = br.resource_id
591: AND EXISTS
592: (SELECT null
593: FROM wip_operation_resources w3,
594: bom_resources br3
595: WHERE w3.wip_entity_id = i_wip_entity_id
596: AND w3.organization_id = i_org_id
597: AND w3.resource_seq_num = w.resource_seq_num
598: AND w3.operation_seq_num = w.operation_seq_num

Line 1019: bom_resources br

1015: AND w.organization_id = i_org_id
1016: AND EXISTS
1017: (SELECT null
1018: FROM wip_operation_resources wor,
1019: bom_resources br
1020: WHERE wor.wip_entity_id = i_wip_entity_id
1021: AND wor.organization_id = i_org_id
1022: AND wor.organization_id = br.organization_id
1023: AND wor.resource_id = br.resource_id

Line 1027: bom_resources br3

1023: AND wor.resource_id = br.resource_id
1024: AND EXISTS
1025: (SELECT null
1026: FROM wip_operation_resources w3,
1027: bom_resources br3
1028: WHERE w3.wip_entity_id = i_wip_entity_id
1029: AND w3.organization_id = i_org_id
1030: AND w3.resource_seq_num = w.resource_seq_num
1031: AND w3.operation_seq_num = w.operation_seq_num

Line 3014: BOM_RESOURCES BR,

3010: i_prog_appl_id,
3011: i_prog_id,
3012: SYSDATE
3013: FROM
3014: BOM_RESOURCES BR,
3015: WIP_OPERATION_RESOURCES WOR
3016: WHERE
3017: WOR.RESOURCE_ID = BR.RESOURCE_ID AND
3018: WOR.ORGANIZATION_ID = BR.ORGANIZATION_ID AND

Line 4539: BOM_RESOURCES BR,

4535: i_prog_appl_id,
4536: i_prog_id,
4537: SYSDATE
4538: FROM
4539: BOM_RESOURCES BR,
4540: WIP_OPERATION_RESOURCES WOR
4541: WHERE
4542: WOR.RESOURCE_ID = BR.RESOURCE_ID AND
4543: WOR.ORGANIZATION_ID = BR.ORGANIZATION_ID AND