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_EAM_UTIL dependencies on BOM_OPERATION_SEQUENCES

Line 40: FROM bom_operation_sequences bos

36: CURSOR c_Nwk_Exists IS
37: SELECT 'Valid Nwk Exists'
38: FROM BOM_OPERATION_NETWORKS bon
39: WHERE exists ( SELECT operation_sequence_id
40: FROM bom_operation_sequences bos
41: WHERE bos.operation_sequence_id = bon.from_op_seq_id
42: AND bos.routing_sequence_id = p_routing_sequence_id
43: AND bos.effectivity_date <= SYSDATE
44: AND nvl(bos.disable_date,SYSDATE+2) > SYSDATE

Line 47: FROM bom_operation_sequences bos2

43: AND bos.effectivity_date <= SYSDATE
44: AND nvl(bos.disable_date,SYSDATE+2) > SYSDATE
45: )
46: AND exists ( SELECT operation_sequence_id
47: FROM bom_operation_sequences bos2
48: WHERE bos2.operation_sequence_id = bon.to_op_seq_id
49: AND bos2.routing_sequence_id = p_routing_sequence_id
50: AND bos2.effectivity_date <= SYSDATE
51: AND nvl(bos2.disable_date,SYSDATE+2) > SYSDATE

Line 91: , BOM_OPERATION_SEQUENCES bos1

87: , bos2.operation_seq_num to_op_seq_num
88: , bon.transition_type transition_type
89: , bon.planning_pct planning_pct
90: FROM BOM_OPERATION_NETWORKS bon
91: , BOM_OPERATION_SEQUENCES bos1
92: , BOM_OPERATION_SEQUENCES bos2
93: WHERE nvl(bon.disable_date,SYSDATE+2) > SYSDATE
94: AND bon.transition_type <> 3
95: AND bos2.effectivity_date <= SYSDATE

Line 92: , BOM_OPERATION_SEQUENCES bos2

88: , bon.transition_type transition_type
89: , bon.planning_pct planning_pct
90: FROM BOM_OPERATION_NETWORKS bon
91: , BOM_OPERATION_SEQUENCES bos1
92: , BOM_OPERATION_SEQUENCES bos2
93: WHERE nvl(bon.disable_date,SYSDATE+2) > SYSDATE
94: AND bon.transition_type <> 3
95: AND bos2.effectivity_date <= SYSDATE
96: AND nvl(bos2.disable_date,SYSDATE+2) > SYSDATE

Line 176: , BOM_OPERATION_SEQUENCES bos1

172: , bos2.operation_seq_num to_op_seq_num
173: , bon.transition_type transition_type
174: , bon.planning_pct planning_pct
175: FROM BOM_OPERATION_NETWORKS bon
176: , BOM_OPERATION_SEQUENCES bos1
177: , BOM_OPERATION_SEQUENCES bos2
178: WHERE NOT EXISTS ( SELECT NULL
179: FROM BOM_OPERATION_NETWORKS bon2
180: WHERE bon2.to_op_seq_id = bon.from_op_seq_id

Line 177: , BOM_OPERATION_SEQUENCES bos2

173: , bon.transition_type transition_type
174: , bon.planning_pct planning_pct
175: FROM BOM_OPERATION_NETWORKS bon
176: , BOM_OPERATION_SEQUENCES bos1
177: , BOM_OPERATION_SEQUENCES bos2
178: WHERE NOT EXISTS ( SELECT NULL
179: FROM BOM_OPERATION_NETWORKS bon2
180: WHERE bon2.to_op_seq_id = bon.from_op_seq_id
181: )

Line 299: FROM bom_operation_sequences

295: FOR all_connected_op_rec IN all_connected_ops LOOP
296: BEGIN
297: SELECT operation_seq_num
298: INTO l_from_op_seq_num
299: FROM bom_operation_sequences
300: WHERE operation_sequence_id =
301: all_connected_op_rec.from_op_seq_id ;
302:
303: SELECT operation_seq_num

Line 305: FROM bom_operation_sequences

301: all_connected_op_rec.from_op_seq_id ;
302:
303: SELECT operation_seq_num
304: INTO l_to_op_seq_num
305: FROM bom_operation_sequences
306: WHERE operation_sequence_id =
307: all_connected_op_rec.to_op_seq_id ;
308:
309:

Line 1275: FROM BOM_OPERATION_SEQUENCES

1271: Cursor op_node_csr( p_operation_sequence_id NUMBER )
1272: IS
1273: SELECT X_COORDINATE
1274: , Y_COORDINATE
1275: FROM BOM_OPERATION_SEQUENCES
1276: WHERE operation_sequence_id = p_operation_sequence_id ;
1277:
1278: op_node_rec op_node_csr%ROWTYPE ;
1279:

Line 1562: UPDATE BOM_OPERATION_SEQUENCES

1558: ('Operatin Sequence: Executing Update Row. . . ') ;
1559: END IF ;
1560:
1561:
1562: UPDATE BOM_OPERATION_SEQUENCES
1563: SET X_Coordinate = p_op_node_rec.x_coordinate
1564: , Y_Coordinate = p_op_node_rec.y_coordinate
1565: , last_update_date = SYSDATE /* Last Update Date */
1566: , last_updated_by = BOM_Rtg_Globals.Get_User_Id /* Last Updated By */

Line 1920: FROM BOM_OPERATION_SEQUENCES bos1

1916: , bos1.operation_seq_num From_Op_Seq_Number
1917: , bos1.effectivity_date From_Start_Effective_Date
1918: , bos2.operation_seq_num To_Op_Seq_Number
1919: , bos2.effectivity_date To_Start_Effective_Date
1920: FROM BOM_OPERATION_SEQUENCES bos1
1921: , BOM_OPERATION_SEQUENCES bos2
1922: WHERE bos1.operation_sequence_id = p_from_op_id
1923: AND bos2.operation_sequence_id = p_to_op_id ;
1924:

Line 1921: , BOM_OPERATION_SEQUENCES bos2

1917: , bos1.effectivity_date From_Start_Effective_Date
1918: , bos2.operation_seq_num To_Op_Seq_Number
1919: , bos2.effectivity_date To_Start_Effective_Date
1920: FROM BOM_OPERATION_SEQUENCES bos1
1921: , BOM_OPERATION_SEQUENCES bos2
1922: WHERE bos1.operation_sequence_id = p_from_op_id
1923: AND bos2.operation_sequence_id = p_to_op_id ;
1924:
1925: nwk_c NUMBER := 0; -- counter for operation network