APPS.BOM_RTG_OI_UTIL dependencies on BOM_OPERATION_SEQUENCES

Line 478: FROM BOM_OPERATION_SEQUENCES BOS1

474: UPDATE BOM_OP_SEQUENCES_INTERFACE BOSI
475: SET(routing_sequence_id, effectivity_date,
476: operation_seq_num, operation_type)
477: = (SELECT routing_sequence_id, effectivity_date, operation_seq_num, operation_type
478: FROM BOM_OPERATION_SEQUENCES BOS1
479: WHERE BOS1.operation_sequence_id = BOSI.operation_sequence_id)
480: WHERE process_flag = 1
481: AND upper(transaction_type) in (G_Delete, G_Update)
482: AND operation_sequence_id is not null

Line 489: FROM BOM_OPERATION_SEQUENCES BOS2

485: ( (p_batch_id IS NULL) AND (BOSI.batch_id IS NULL) )
486: OR ( p_batch_id = BOSI.batch_id )
487: )
488: AND exists (SELECT 'x'
489: FROM BOM_OPERATION_SEQUENCES BOS2
490: WHERE BOS2.operation_sequence_id = BOSI.operation_sequence_id );
491:
492:
493: stmt_num := 2;

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:

Line 1039: FROM BOM_OPERATION_SEQUENCES BOS1

1035:
1036: UPDATE BOM_OP_RESOURCES_INTERFACE BORI
1037: SET(routing_sequence_id, effectivity_date, operation_seq_num)
1038: = (SELECT routing_sequence_id, effectivity_date, operation_seq_num
1039: FROM BOM_OPERATION_SEQUENCES BOS1
1040: WHERE BOS1.operation_sequence_id = BORI.operation_sequence_id )
1041: WHERE process_flag = 1
1042: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)
1043: AND OPERATION_SEQUENCE_ID is not null

Line 1050: FROM BOM_OPERATION_SEQUENCES BOS2

1046: ( (p_batch_id IS NULL) AND (BORI.batch_id IS NULL) )
1047: OR ( p_batch_id = BORI.batch_id )
1048: )
1049: AND exists (SELECT 'x'
1050: FROM BOM_OPERATION_SEQUENCES BOS2
1051: WHERE BOS2.OPERATION_SEQUENCE_ID = BORI.OPERATION_SEQUENCE_ID);
1052:
1053:
1054: stmt_num := 2;

Line 1316: FROM BOM_OPERATION_SEQUENCES BOS1

1312:
1313: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI
1314: SET(routing_sequence_id, effectivity_date, operation_seq_num)
1315: = (select routing_sequence_id, EFFECTIVITY_DATE, OPERATION_SEQ_NUM
1316: FROM BOM_OPERATION_SEQUENCES BOS1
1317: WHERE BOS1.OPERATION_SEQUENCE_ID = BSORI.operation_sequence_id)
1318: WHERE process_flag = 1
1319: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)
1320: AND OPERATION_SEQUENCE_ID is not null

Line 1327: FROM BOM_OPERATION_SEQUENCES BOS2

1323: ( (p_batch_id IS NULL) AND (BSORI.batch_id IS NULL) )
1324: OR ( p_batch_id = BSORI.batch_id )
1325: )
1326: AND exists (SELECT 'x'
1327: FROM BOM_OPERATION_SEQUENCES BOS2
1328: WHERE BOS2.OPERATION_SEQUENCE_ID = BSORI.OPERATION_SEQUENCE_ID);
1329:
1330:
1331: stmt_num := 2;

Line 1593: FROM BOM_OPERATION_SEQUENCES BOS1

1589:
1590: UPDATE BOM_OP_NETWORKS_INTERFACE BONI
1591: SET(routing_sequence_id, from_op_seq_number, from_start_effective_date)
1592: = (SELECT routing_sequence_id, operation_seq_num, effectivity_date
1593: FROM BOM_OPERATION_SEQUENCES BOS1
1594: WHERE BOS1.operation_sequence_id = BONI.from_Op_seq_id)
1595: WHERE process_flag = 1
1596: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)
1597: AND BONI.from_Op_seq_id is not null

Line 1604: FROM BOM_OPERATION_SEQUENCES BOS2

1600: ( (p_batch_id IS NULL) AND (BONI.batch_id IS NULL) )
1601: OR ( p_batch_id = BONI.batch_id )
1602: )
1603: AND exists (SELECT 'x'
1604: FROM BOM_OPERATION_SEQUENCES BOS2
1605: WHERE BOS2.OPERATION_SEQUENCE_ID = BONI.FROM_OP_SEQ_ID );
1606:
1607: UPDATE BOM_OP_NETWORKS_INTERFACE BONI
1608: SET(routing_sequence_id, to_op_seq_number, to_start_effective_date)

Line 1610: FROM BOM_OPERATION_SEQUENCES BOS1

1606:
1607: UPDATE BOM_OP_NETWORKS_INTERFACE BONI
1608: SET(routing_sequence_id, to_op_seq_number, to_start_effective_date)
1609: = (SELECT routing_sequence_id, operation_seq_num, effectivity_date
1610: FROM BOM_OPERATION_SEQUENCES BOS1
1611: WHERE BOS1.operation_sequence_id = BONI.to_Op_seq_id)
1612: WHERE process_flag = 1
1613: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)
1614: AND BONI.to_Op_seq_id is not null

Line 1621: FROM BOM_OPERATION_SEQUENCES BOS2

1617: ( (p_batch_id IS NULL) AND (BONI.batch_id IS NULL) )
1618: OR ( p_batch_id = BONI.batch_id )
1619: )
1620: AND exists (SELECT 'x'
1621: FROM BOM_OPERATION_SEQUENCES BOS2
1622: WHERE BOS2.OPERATION_SEQUENCE_ID = BONI.TO_OP_SEQ_ID );
1623:
1624:
1625: stmt_num := 2;