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.GMO_INSTR_ENTITY_PVT dependencies on GMD_OPERATION_ACTIVITIES

Line 58: select activity from gmd_operation_activities where oprn_line_id = l_oprn_line_id;

54: and c.recipe_id = l_recipe_id and b.routingstep_id = l_routingstep_id and a.oprn_id = l_oprn_id;
55:
56:
57: cursor get_activity is
58: select activity from gmd_operation_activities where oprn_line_id = l_oprn_line_id;
59:
60: cursor get_routing_activity is
61: select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'ROUTING') || ' ' || c.routing_no || ' : ' || d.activity
62: from gmd_operations a, fm_rout_dtl b, gmd_routings c, gmd_operation_activities d

Line 62: from gmd_operations a, fm_rout_dtl b, gmd_routings c, gmd_operation_activities d

58: select activity from gmd_operation_activities where oprn_line_id = l_oprn_line_id;
59:
60: cursor get_routing_activity is
61: select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'ROUTING') || ' ' || c.routing_no || ' : ' || d.activity
62: from gmd_operations a, fm_rout_dtl b, gmd_routings c, gmd_operation_activities d
63: where a.oprn_id = b.oprn_id
64: and c.routing_id = b.routing_id
65: and a.oprn_id = d.oprn_id
66: and d.oprn_line_id = l_oprn_line_id

Line 71: from gmd_operations a, fm_rout_dtl b, gmd_recipes c, gmd_operation_activities d

67: and b.routingstep_id = l_routingstep_id;
68:
69: cursor get_recipe_activity is
70: select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'RECIPE') || ' ' || recipe_no || ' : ' || d.activity
71: from gmd_operations a, fm_rout_dtl b, gmd_recipes c, gmd_operation_activities d
72: where a.oprn_id = b.oprn_id and b.routing_id = c.routing_id and a.oprn_id = d.oprn_id
73: and b.routingstep_id = l_routingstep_id
74: and c.recipe_id = l_recipe_id
75: and d.oprn_line_id = l_oprn_line_id;

Line 79: from gmd_operation_activities a, gmd_operation_resources b

75: and d.oprn_line_id = l_oprn_line_id;
76:
77: cursor get_resource is
78: select b.resources
79: from gmd_operation_activities a, gmd_operation_resources b
80: where a.oprn_line_id = b.oprn_line_id
81: and a.oprn_line_id = l_oprn_line_id
82: and b.resources = l_resources;
83:

Line 87: from gmd_operations a, fm_rout_dtl b, gmd_routings c, gmd_operation_activities d, gmd_operation_resources e

83:
84: cursor get_routing_resource is
85:
86: select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'ROUTING') || ' ' || c.routing_no || ' : ' || e.resources
87: from gmd_operations a, fm_rout_dtl b, gmd_routings c, gmd_operation_activities d, gmd_operation_resources e
88: where a.oprn_id = b.oprn_id
89: and c.routing_id = b.routing_id
90: and a.oprn_id = d.oprn_id
91: and d.oprn_line_id = e.oprn_line_id

Line 98: from gmd_operations a, fm_rout_dtl b, gmd_recipes c, gmd_operation_activities d, gmd_operation_resources e

94: and e.resources = l_resources;
95:
96: cursor get_recipe_resource is
97: select gmo_utilities.get_lookup_meaning ('GMO_INSTR_ENTITY_CODES', 'RECIPE') || ' ' || recipe_no || ' : ' || e.resources
98: from gmd_operations a, fm_rout_dtl b, gmd_recipes c, gmd_operation_activities d, gmd_operation_resources e
99: where a.oprn_id = b.oprn_id and b.routing_id = c.routing_id and a.oprn_id = d.oprn_id and d.oprn_line_id = e.oprn_line_id
100: and c.recipe_id = l_recipe_id
101: and b.routingstep_id = l_routingstep_id
102: and e.oprn_line_id = l_oprn_line_id

Line 329: cursor get_old_oprn_line is select oprn_line_id FROM gmd_operation_activities where oprn_id = l_source_oprn_id order by oprn_line_id;

325: l_target_oprn_id number;
326:
327: cursor get_task_name is select task_name from gmo_instr_task_defn_b where task_id = P_TASK_ID;
328:
329: cursor get_old_oprn_line is select oprn_line_id FROM gmd_operation_activities where oprn_id = l_source_oprn_id order by oprn_line_id;
330: cursor get_new_oprn_line is select oprn_line_id FROM gmd_operation_activities where oprn_id = l_target_oprn_id order by oprn_line_id;
331:
332: BEGIN
333:

Line 330: cursor get_new_oprn_line is select oprn_line_id FROM gmd_operation_activities where oprn_id = l_target_oprn_id order by oprn_line_id;

326:
327: cursor get_task_name is select task_name from gmo_instr_task_defn_b where task_id = P_TASK_ID;
328:
329: cursor get_old_oprn_line is select oprn_line_id FROM gmd_operation_activities where oprn_id = l_source_oprn_id order by oprn_line_id;
330: cursor get_new_oprn_line is select oprn_line_id FROM gmd_operation_activities where oprn_id = l_target_oprn_id order by oprn_line_id;
331:
332: BEGIN
333:
334: l_task_name := '';