DBA Data[Home] [Help]

APPS.BOM_RTG_VAL_TO_ID dependencies on BOM_STANDARD_OPERATIONS

Line 430: FROM bom_standard_operations bso

426: BEGIN
427:
428: SELECT standard_operation_id
429: INTO l_id
430: FROM bom_standard_operations bso
431: -- , eng_revised_items eri
432: WHERE NVL(bso.operation_type, 1)
433: = DECODE(p_operation_type, FND_API.G_MISS_NUM, 1
434: , NVL(p_operation_type, 1 ) )

Line 484: FROM bom_standard_operations bso

480: BEGIN
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))

Line 569: , BOM_STANDARD_OPERATIONS bso

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
573: AND bos.operation_type = 2 -- Operation Type : Process

Line 581: , BOM_STANDARD_OPERATIONS bso

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
585: AND bos.operation_seq_num = p_process_seq_number

Line 640: , BOM_STANDARD_OPERATIONS bso

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
644: AND bos.operation_type = 3 -- Operation Type : Line Op

Line 652: , BOM_STANDARD_OPERATIONS bso

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
656: AND bos.operation_seq_num = p_line_seq_number