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.BOM_RTG_VAL_TO_ID dependencies on BOM_OPERATIONAL_ROUTINGS

Line 200: FROM bom_operational_routings

196: SELECT routing_sequence_id
197: , cfm_routing_flag
198: , common_routing_sequence_id
199: INTO l_id, l_cfm_flag, l_com_rtg_seq_id
200: FROM bom_operational_routings
201: WHERE organization_id = p_organization_id
202: AND assembly_item_id = p_assembly_item_id
203: AND NVL(alternate_routing_designator, FND_API.G_MISS_CHAR) =
204: NVL(p_alternate_routing_designator, FND_API.G_MISS_CHAR);

Line 485: , bom_operational_routings bor

481:
482: SELECT standard_operation_id
483: INTO l_id
484: FROM bom_standard_operations bso
485: , bom_operational_routings bor
486: WHERE NVL(bso.operation_type,1 )
487: = DECODE(p_operation_type, FND_API.G_MISS_NUM, 1
488: , NVL(p_operation_type, 1))
489: AND NVL(bso.line_id, FND_API.G_MISS_NUM)

Line 568: , BOM_OPERATIONAL_ROUTINGS bor

564: IF p_process_code IS NULL THEN -- Added for bug 2758481
565: SELECT bos.operation_sequence_id
566: INTO l_id
567: FROM BOM_OPERATION_SEQUENCES bos
568: , BOM_OPERATIONAL_ROUTINGS bor
569: , BOM_STANDARD_OPERATIONS bso
570: WHERE bso.organization_id = p_organization_id
571: AND bso.standard_operation_id = bos.standard_operation_id
572: AND bos.operation_seq_num = p_process_seq_number

Line 580: , BOM_OPERATIONAL_ROUTINGS bor

576: ELSE
577: SELECT bos.operation_sequence_id
578: INTO l_id
579: FROM BOM_OPERATION_SEQUENCES bos
580: , BOM_OPERATIONAL_ROUTINGS bor
581: , BOM_STANDARD_OPERATIONS bso
582: WHERE bso.operation_code = p_process_code
583: AND bso.organization_id = p_organization_id
584: AND bso.standard_operation_id = bos.standard_operation_id

Line 639: , BOM_OPERATIONAL_ROUTINGS bor

635: IF p_line_code IS NULL THEN -- Added for bug 2758481
636: SELECT bos.operation_sequence_id
637: INTO l_id
638: FROM BOM_OPERATION_SEQUENCES bos
639: , BOM_OPERATIONAL_ROUTINGS bor
640: , BOM_STANDARD_OPERATIONS bso
641: WHERE bso.organization_id = p_organization_id
642: AND bso.standard_operation_id = bos.standard_operation_id
643: AND bos.operation_seq_num = p_line_seq_number

Line 651: , BOM_OPERATIONAL_ROUTINGS bor

647: ELSE
648: SELECT bos.operation_sequence_id
649: INTO l_id
650: FROM BOM_OPERATION_SEQUENCES bos
651: , BOM_OPERATIONAL_ROUTINGS bor
652: , BOM_STANDARD_OPERATIONS bso
653: WHERE bso.operation_code = p_line_code
654: AND bso.organization_id = p_organization_id
655: AND bso.standard_operation_id = bos.standard_operation_id