DBA Data[Home] [Help]

APPS.BOM_RTG_VAL_TO_ID dependencies on BOM_OPERATION_SEQUENCES

Line 567: FROM BOM_OPERATION_SEQUENCES bos

563: BEGIN
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

Line 579: FROM BOM_OPERATION_SEQUENCES bos

575: AND bor.routing_sequence_id = p_routing_sequence_id ;
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

Line 638: FROM BOM_OPERATION_SEQUENCES bos

634:
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

Line 650: FROM BOM_OPERATION_SEQUENCES bos

646: AND bor.routing_sequence_id = p_routing_sequence_id ;
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

Line 710: FROM BOM_OPERATION_SEQUENCES

706: END IF;
707:
708: SELECT operation_sequence_id
709: INTO l_id
710: FROM BOM_OPERATION_SEQUENCES
711: WHERE NVL(operation_type, 1) = DECODE(p_operation_type,
712: FND_API.G_MISS_NUM, 1,
713: NVL(p_operation_type, 1)
714: )

Line 876: FROM bom_operation_sequences

872: l_bo_id := BOM_Rtg_Globals.Get_Bo_Identifier ;
873:
874: SELECT operation_sequence_id
875: INTO l_id
876: FROM bom_operation_sequences
877: WHERE (( l_bo_id = BOM_Rtg_Globals.G_ECO_BO
878: AND implementation_date IS NULL )
879: OR (l_bo_id = BOM_Rtg_Globals.G_RTG_BO
880: AND implementation_date IS NOT NULL )