APPS.BOM_RTG_OI_UTIL dependencies on BOM_STANDARD_OPERATIONS

Line 615: FROM BOM_STANDARD_OPERATIONS bso

611: /* Update the operation code from the standard operation id */
612:
613: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
614: SET operation_code = (SELECT operation_code
615: FROM BOM_STANDARD_OPERATIONS bso
616: WHERE bso.standard_operation_id = BOSI.standard_operation_id
617: and bso.organization_id = BOSI.organization_id)
618: WHERE process_flag = 1
619: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 628: FROM BOM_STANDARD_OPERATIONS bso

624: ( (p_batch_id IS NULL) AND (BOSI.batch_id IS NULL) )
625: OR ( p_batch_id = BOSI.batch_id )
626: )
627: AND exists (SELECT 'x'
628: FROM BOM_STANDARD_OPERATIONS bso
629: WHERE bso.standard_operation_id = BOSI.standard_operation_id
630: and bso.organization_id = BOSI.organization_id);
631:
632: stmt_num := 8;

Line 650: FROM BOM_STANDARD_OPERATIONS bso

646: ( (p_batch_id IS NULL) AND (BOSI.batch_id IS NULL) )
647: OR ( p_batch_id = BOSI.batch_id )
648: )
649: AND exists (SELECT 'x'
650: FROM BOM_STANDARD_OPERATIONS bso
651: WHERE bso.department_id = BOSI.department_id
652: and bso.organization_id = BOSI.organization_id);
653:
654: stmt_num := 9;

Line 660: FROM BOM_OPERATION_SEQUENCES BOS1, BOM_STANDARD_OPERATIONS BSO1

656:
657: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
658: SET(line_op_seq_number, line_op_code)
659: = (SELECT bos1.operation_seq_num, bso1.operation_code
660: FROM BOM_OPERATION_SEQUENCES BOS1, BOM_STANDARD_OPERATIONS BSO1
661: WHERE BOS1.operation_sequence_id = BOSI.line_op_seq_id
662: AND BSO1.organization_id = BOSI.organization_id
663: AND BOS1.standard_operation_id = BSO1.standard_operation_id)
664: WHERE process_flag = 1

Line 673: FROM BOM_OPERATION_SEQUENCES BOS1, BOM_STANDARD_OPERATIONS BSO1

669: ( (p_batch_id IS NULL) AND (BOSI.batch_id IS NULL) )
670: OR ( p_batch_id = BOSI.batch_id )
671: )
672: AND exists (SELECT 'x'
673: FROM BOM_OPERATION_SEQUENCES BOS1, BOM_STANDARD_OPERATIONS BSO1
674: WHERE BOS1.operation_sequence_id = BOSI.line_op_seq_id
675: AND BSO1.organization_id = BOSI.organization_id
676: AND BOS1.standard_operation_id = BSO1.standard_operation_id);
677:

Line 681: FROM BOM_OPERATION_SEQUENCES BOS1, BOM_STANDARD_OPERATIONS BSO1

677:
678: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
679: SET(process_seq_number, process_code)
680: = (SELECT bos1.operation_seq_num, bso1.operation_code
681: FROM BOM_OPERATION_SEQUENCES BOS1, BOM_STANDARD_OPERATIONS BSO1
682: WHERE BOS1.operation_sequence_id = BOSI.process_op_seq_id
683: AND BSO1.organization_id = BOSI.organization_id
684: AND BOS1.standard_operation_id = BSO1.standard_operation_id)
685: WHERE process_flag = 1

Line 694: FROM BOM_OPERATION_SEQUENCES BOS1, BOM_STANDARD_OPERATIONS BSO1

690: ( (p_batch_id IS NULL) AND (BOSI.batch_id IS NULL) )
691: OR ( p_batch_id = BOSI.batch_id )
692: )
693: AND exists (SELECT 'x'
694: FROM BOM_OPERATION_SEQUENCES BOS1, BOM_STANDARD_OPERATIONS BSO1
695: WHERE BOS1.operation_sequence_id = BOSI.process_op_seq_id
696: AND BSO1.organization_id = BOSI.organization_id
697: AND BOS1.standard_operation_id = BSO1.standard_operation_id);
698: