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

Line 216: -- Update bom_operation sequences to set the X and Y coordinates

212: , Fnd_Global.Conc_Program_Id
213: , Fnd_Global.Prog_Appl_Id
214: , SYSDATE
215: );
216: -- Update bom_operation sequences to set the X and Y coordinates
217: -- for the operations involved in this network.
218: update BOM_OPERATION_SEQUENCES set
219: X_COORDINATE = p_op_network_rec.From_X_Coordinate
220: ,Y_COORDINATE = p_op_network_rec.From_Y_Coordinate

Line 218: update BOM_OPERATION_SEQUENCES set

214: , SYSDATE
215: );
216: -- Update bom_operation sequences to set the X and Y coordinates
217: -- for the operations involved in this network.
218: update BOM_OPERATION_SEQUENCES set
219: X_COORDINATE = p_op_network_rec.From_X_Coordinate
220: ,Y_COORDINATE = p_op_network_rec.From_Y_Coordinate
221: , last_update_date = SYSDATE
222: , last_updated_by = BOM_Rtg_Globals.Get_User_Id

Line 231: update BOM_OPERATION_SEQUENCES set

227: , program_update_date = SYSDATE
228: where operation_sequence_id =
229: p_op_network_unexp_rec.from_op_seq_id;
230:
231: update BOM_OPERATION_SEQUENCES set
232: X_COORDINATE = p_op_network_rec.To_X_Coordinate
233: ,Y_COORDINATE = p_op_network_rec.To_Y_Coordinate
234: , last_update_date = SYSDATE
235: , last_updated_by = BOM_Rtg_Globals.Get_User_Id

Line 327: -- Update bom_operation sequences to set the X and Y coordinates

323: , program_update_date = SYSDATE
324: WHERE from_op_seq_id = p_op_network_unexp_rec.from_op_seq_id
325: AND to_op_seq_id = p_op_network_unexp_rec.to_op_seq_id;
326:
327: -- Update bom_operation sequences to set the X and Y coordinates
328: -- for the operations involved in this network.
329: update BOM_OPERATION_SEQUENCES set
330: X_COORDINATE = p_op_network_rec.From_X_Coordinate
331: ,Y_COORDINATE = p_op_network_rec.From_Y_Coordinate

Line 329: update BOM_OPERATION_SEQUENCES set

325: AND to_op_seq_id = p_op_network_unexp_rec.to_op_seq_id;
326:
327: -- Update bom_operation sequences to set the X and Y coordinates
328: -- for the operations involved in this network.
329: update BOM_OPERATION_SEQUENCES set
330: X_COORDINATE = p_op_network_rec.From_X_Coordinate
331: ,Y_COORDINATE = p_op_network_rec.From_Y_Coordinate
332: , last_update_date = SYSDATE
333: , last_updated_by = BOM_Rtg_Globals.Get_User_Id

Line 345: update BOM_OPERATION_SEQUENCES set

341: NULL , p_op_network_unexp_rec.from_op_seq_id,
342: p_op_network_unexp_rec.new_from_op_seq_id);
343:
344:
345: update BOM_OPERATION_SEQUENCES set
346: X_COORDINATE = p_op_network_rec.To_X_Coordinate
347: ,Y_COORDINATE = p_op_network_rec.To_Y_Coordinate
348: , last_update_date = SYSDATE
349: , last_updated_by = BOM_Rtg_Globals.Get_User_Id

Line 786: FROM BOM_OPERATION_SEQUENCES bos

782: IS
783: -- Get the First Operation of the network ordered by descending effectivity date
784: CURSOR First_Op_Of_Nw( c_routing_sequence_id NUMBER ) IS
785: SELECT bos.OPERATION_SEQUENCE_ID, bos.DISABLE_DATE
786: FROM BOM_OPERATION_SEQUENCES bos
787: WHERE
788: bos.IMPLEMENTATION_DATE IS NOT NULL
789: AND bos.OPERATION_SEQ_NUM IN
790: ( SELECT bos_first.OPERATION_SEQ_NUM

Line 794: BOM_OPERATION_SEQUENCES bos_first

790: ( SELECT bos_first.OPERATION_SEQ_NUM
791: FROM
792: BOM_OPERATION_NETWORKS bon_from,
793: BOM_OPERATION_NETWORKS bon_to,
794: BOM_OPERATION_SEQUENCES bos_first
795: WHERE
796: bon_from.FROM_OP_SEQ_ID = bos_first.OPERATION_SEQUENCE_ID
797: AND bon_from.TO_OP_SEQ_ID = bon_to.FROM_OP_SEQ_ID
798: AND bon_from.FROM_OP_SEQ_ID <> bon_to.FROM_OP_SEQ_ID

Line 807: FROM BOM_OPERATION_SEQUENCES bos

803:
804: -- Get the Last Operation of the network ordered by descending effectivity date
805: CURSOR Last_Op_Of_Nw( c_routing_sequence_id NUMBER ) IS
806: SELECT bos.OPERATION_SEQUENCE_ID, bos.DISABLE_DATE
807: FROM BOM_OPERATION_SEQUENCES bos
808: WHERE
809: bos.IMPLEMENTATION_DATE IS NOT NULL
810: AND bos.OPERATION_SEQ_NUM IN
811: ( SELECT bos_last.OPERATION_SEQ_NUM

Line 815: BOM_OPERATION_SEQUENCES bos_last

811: ( SELECT bos_last.OPERATION_SEQ_NUM
812: FROM
813: BOM_OPERATION_NETWORKS bon_from,
814: BOM_OPERATION_NETWORKS bon_to,
815: BOM_OPERATION_SEQUENCES bos_last
816: WHERE
817: bon_to.TO_OP_SEQ_ID = bos_last.OPERATION_SEQUENCE_ID
818: AND bon_from.TO_OP_SEQ_ID = bon_to.FROM_OP_SEQ_ID
819: AND bon_to.TO_OP_SEQ_ID <> bon_from.TO_OP_SEQ_ID

Line 877: SELECT BOM_OPERATION_SEQUENCES_S.NEXTVAL

873: Error_Handler.Write_Debug( ' Copying operation ' || p_operation_sequence_id );
874: END IF;
875:
876: -- Get a new operation sequence id
877: SELECT BOM_OPERATION_SEQUENCES_S.NEXTVAL
878: INTO l_op_seq_id
879: FROM DUAL;
880:
881: -- Copy the disabled operation with effectivity date as disable date plus one minute

Line 882: INSERT INTO BOM_OPERATION_SEQUENCES

878: INTO l_op_seq_id
879: FROM DUAL;
880:
881: -- Copy the disabled operation with effectivity date as disable date plus one minute
882: INSERT INTO BOM_OPERATION_SEQUENCES
883: (
884: OPERATION_SEQUENCE_ID,
885: ROUTING_SEQUENCE_ID,
886: OPERATION_SEQ_NUM,

Line 1021: BOM_OPERATION_SEQUENCES BOS

1017: BOS.SHOW_SCRAP_CODE,
1018: BOS.SHOW_LOT_ATTRIB,
1019: BOS.TRACK_MULTIPLE_RES_USAGE_DATES
1020: FROM
1021: BOM_OPERATION_SEQUENCES BOS
1022: WHERE
1023: BOS.OPERATION_SEQUENCE_ID = p_operation_sequence_id;
1024:
1025: -- Copy Operation Resources