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 BOM_OPERATION_SEQUENCES

Line 480: FROM BOM_OPERATION_SEQUENCES BOS1

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

Line 491: FROM BOM_OPERATION_SEQUENCES BOS2

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

Line 662: FROM BOM_OPERATION_SEQUENCES BOS1, BOM_STANDARD_OPERATIONS BSO1

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

Line 675: FROM BOM_OPERATION_SEQUENCES BOS1, BOM_STANDARD_OPERATIONS BSO1

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

Line 683: FROM BOM_OPERATION_SEQUENCES BOS1, BOM_STANDARD_OPERATIONS BSO1

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

Line 696: FROM BOM_OPERATION_SEQUENCES BOS1, BOM_STANDARD_OPERATIONS BSO1

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

Line 1041: FROM BOM_OPERATION_SEQUENCES BOS1

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

Line 1052: FROM BOM_OPERATION_SEQUENCES BOS2

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

Line 1318: FROM BOM_OPERATION_SEQUENCES BOS1

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

Line 1329: FROM BOM_OPERATION_SEQUENCES BOS2

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

Line 1595: FROM BOM_OPERATION_SEQUENCES BOS1

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

Line 1606: FROM BOM_OPERATION_SEQUENCES BOS2

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

Line 1612: FROM BOM_OPERATION_SEQUENCES BOS1

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

Line 1623: FROM BOM_OPERATION_SEQUENCES BOS2

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