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.PMI_PRODUCTION_SUM dependencies on SY_ORGN_MST

Line 34: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og

30: bd.item_id,
31: '1',
32: count(*),
33: sysdate
34: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og
35: where bh.batch_id = bd.batch_id
36: and line_type = 1
37: and bh.plant_CODE = og.ORGN_CODE
38: and og.CO_CODE = cl.CO_CODE

Line 72: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og

68: bd.item_id,
69: '3',
70: count(*),
71: sysdate
72: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og
73: where bh.batch_id = bd.batch_id
74: and line_type = 1
75: and bh.plant_CODE = og.ORGN_CODE
76: and og.CO_CODE = cl.CO_CODE

Line 111: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og

107: bd.item_id,
108: '2',
109: count(*),
110: sysdate
111: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og
112: where bh.batch_id = bd.batch_id
113: and bh.batch_status > 1
114: and line_type = 1
115: and bh.plant_CODE = og.ORGN_CODE

Line 150: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og

146: bd.item_id,
147: '4',
148: count(*),
149: sysdate
150: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og
151: where bh.batch_id = bd.batch_id
152: and bh.batch_status > 2
153: and line_type = 1
154: and bh.plant_CODE = og.ORGN_CODE

Line 189: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og

185: bd.item_id,
186: '5',
187: count(*),
188: sysdate
189: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og
190: where bh.batch_id = bd.batch_id
191: and bh.batch_status = 4
192: and line_type = 1
193: and bh.plant_CODE = og.ORGN_CODE

Line 229: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og

225: bd.item_id,
226: '6',
227: count(*),
228: sysdate
229: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og
230: where bh.batch_id = bd.batch_id
231: and bh.batch_status = -1
232: and line_type = 1
233: and bh.plant_CODE = og.ORGN_CODE