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_OI_UTIL dependencies on STANDARD

Line 611: /* Update the operation code from the standard operation id */

607: (all_org = 2 AND organization_id = org_id));
608:
609:
610: stmt_num := 7;
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

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 616: WHERE bso.standard_operation_id = BOSI.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)
620: AND standard_operation_id is not null

Line 620: AND standard_operation_id is not null

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)
620: AND standard_operation_id is not null
621: AND organization_id is not null
622: AND
623: (
624: ( (p_batch_id IS NULL) AND (BOSI.batch_id IS NULL) )

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 629: WHERE bso.standard_operation_id = BOSI.standard_operation_id

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;
633: /* Update the department code from the department id */

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 663: AND BOS1.standard_operation_id = BSO1.standard_operation_id)

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
665: AND upper(transaction_type) in (G_Delete, G_Update)
666: AND line_op_seq_id is not null
667: AND

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 676: AND BOS1.standard_operation_id = BSO1.standard_operation_id);

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:
678: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
679: SET(process_seq_number, process_code)
680: = (SELECT bos1.operation_seq_num, bso1.operation_code

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 684: AND BOS1.standard_operation_id = BSO1.standard_operation_id)

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
686: AND upper(transaction_type) in (G_Delete, G_Update)
687: AND process_op_seq_id is not null
688: AND

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:

Line 697: AND BOS1.standard_operation_id = BSO1.standard_operation_id);

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:
699: stmt_num := 10;
700: /* Update the delete_group_name from bom_interface_delete_groups */
701: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI