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.GMD_FETCH_OPRN dependencies on GMD_OPERATIONS_VL

Line 21: FROM gmd_operations_vl

17: ) IS
18:
19: CURSOR Cur_validate_record IS
20: SELECT 1
21: FROM gmd_operations_vl
22: WHERE oprn_id = p_oprn_id;
23: X_count NUMBER;
24: INVALID_OPERATION EXCEPTION;
25: -- Bug #2415756 (JKB) Added cursor above.

Line 125: from gmd_operations_vl o, gmd_operation_activities a, fm_actv_mst fm

121: a.attribute17, a.attribute18, a.attribute19, a.attribute20,
122: a.attribute21, a.attribute22, a.attribute23, a.attribute24,
123: a.attribute25, a.attribute26, a.attribute27, a.attribute28,
124: a.attribute29, a.attribute30
125: from gmd_operations_vl o, gmd_operation_activities a, fm_actv_mst fm
126: where a.oprn_id = p_oprn_id
127: and a.oprn_id = o.oprn_id
128: and a.activity = fm.activity
129: --Added the order by for the bug 12613037.

Line 272: FROM gmd_operations_vl o,gmd_operation_activities a, gmd_operation_resources res,

268: res.attribute17, res.attribute18, res.attribute19, res.attribute20,
269: res.attribute21, res.attribute22,res.attribute23, res.attribute24,
270: res.attribute25, res.attribute26, res.attribute27, res.attribute28,
271: res.attribute29, res.attribute30
272: FROM gmd_operations_vl o,gmd_operation_activities a, gmd_operation_resources res,
273: cr_rsrc_mst m, cr_rsrc_dtl l
274: where a.oprn_id = p_oprn_id
275: and o.oprn_id = a.oprn_id
276: and a.oprn_line_id = res.oprn_line_id