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.EGO_IMPORT_BATCH_PURGE_PKG dependencies on BOM_OP_SEQUENCES_INTERFACE

Line 884: --delete records from bom_op_sequences_interface

880: AND boni.assembly_item_id = l_op_table(op).assembly_item_id;
881: */
882:
883:
884: --delete records from bom_op_sequences_interface
885: stm_num := 11;
886:
887: FORALL op IN l_routing_table.first .. l_routing_table.last
888:

Line 889: DELETE FROM bom_op_sequences_interface bseq

885: stm_num := 11;
886:
887: FORALL op IN l_routing_table.first .. l_routing_table.last
888:
889: DELETE FROM bom_op_sequences_interface bseq
890: WHERE bseq.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
891: AND bseq.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
892: AND bseq.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
893: AND bseq.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id

Line 1147: DELETE bom_op_sequences_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);

1143:
1144:
1145: stm_num :=17;
1146:
1147: DELETE bom_op_sequences_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1148:
1149: fnd_file.put_line(fnd_file.Log,'No.of Operation sequences deleted are '||SQL%ROWCOUNT);
1150:
1151: