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.GME_MOBILE_LOVS dependencies on GME_BATCH_HEADER

Line 156: FROM gme_batch_header b,

152: ,batch_status
153: ,batch_id
154: ,NVL(formula_id,0)
155: ,NVL(routing_id,0)
156: FROM gme_batch_header b,
157: gem_lookups lkup
158: WHERE organization_id = p_org_id
159: AND batch_type= 0
160: AND batch_status in (1,2)

Line 183: FROM gme_batch_header b,

179: ,batch_status
180: ,batch_id
181: ,NVL(formula_id,0)
182: ,NVL(routing_id,0)
183: FROM gme_batch_header b,
184: gem_lookups lkup
185: WHERE organization_id = p_org_id
186: AND batch_type= 0
187: AND batch_status = 2

Line 209: FROM gme_batch_header b,

205: ,batch_status
206: ,batch_id
207: ,NVL(formula_id,0)
208: ,NVL(routing_id,0)
209: FROM gme_batch_header b,
210: gem_lookups lkup
211: WHERE organization_id = p_org_id
212: AND batch_type= 0
213: AND batch_status in (2,3)

Line 235: FROM gme_batch_header b,

231: ,batch_status
232: ,batch_id
233: ,NVL(formula_id,0)
234: ,NVL(routing_id,0)
235: FROM gme_batch_header b,
236: gem_lookups lkup
237: WHERE organization_id = p_org_id
238: AND batch_type= 0
239: AND batch_status in (2,3)

Line 262: FROM gme_batch_header b,

258: ,batch_status
259: ,batch_id
260: ,NVL(formula_id,0)
261: ,NVL(routing_id,0)
262: FROM gme_batch_header b,
263: gem_lookups lkup
264: WHERE organization_id = p_org_id
265: AND batch_type= 0
266: AND batch_status in (2,3)

Line 294: FROM gme_batch_header h,

290: ,batch_status
291: ,batch_id
292: ,NVL(formula_id,0)
293: ,NVL(routing_id,0)
294: FROM gme_batch_header h,
295: gem_lookups lkup
296: WHERE organization_id = p_org_id
297: AND batch_type= 0
298: AND batch_status = 3

Line 327: FROM gme_batch_header b,

323: ,batch_status
324: ,batch_id
325: ,NVL(formula_id,0)
326: ,NVL(routing_id,0)
327: FROM gme_batch_header b,
328: gem_lookups lkup
329: WHERE organization_id = p_org_id
330: AND batch_type= 0
331: AND batch_status in (1,2)

Line 1105: FROM gme_batch_header h,

1101: BEGIN
1102: OPEN x_activity_cursor FOR
1103: SELECT a.activity,
1104: a.batchstep_activity_id
1105: FROM gme_batch_header h,
1106: gme_batch_steps s,
1107: gme_batch_step_activities a
1108: WHERE h.organization_id = p_organization_id
1109: AND h.batch_id = p_batch_id

Line 1155: FROM gme_batch_header h,

1151:
1152: OPEN x_resource_cursor FOR
1153: SELECT r.resources,
1154: r.batchstep_resource_id
1155: FROM gme_batch_header h,
1156: gme_batch_steps s,
1157: gme_batch_step_activities a,
1158: gme_batch_step_resources r
1159: WHERE h.organization_id = p_org_id

Line 2157: FROM gme_batch_header h,

2153: OPEN x_step_cursor FOR
2154: SELECT s.batchstep_no,
2155: o.oprn_desc,
2156: s.batchstep_id
2157: FROM gme_batch_header h,
2158: gme_batch_steps s,
2159: gmd_operations o
2160: WHERE h.batch_id = p_batch_id
2161: AND h.batch_type = 0

Line 2172: FROM gme_batch_header h,

2168: UNION
2169: SELECT s.batchstep_no,
2170: o.oprn_desc,
2171: s.batchstep_id
2172: FROM gme_batch_header h,
2173: gme_batch_steps s,
2174: gmd_operations o
2175: WHERE h.batch_id = p_batch_id
2176: AND h.batch_type = 0

Line 3523: FROM gme_batch_header h,

3519: OPEN x_line_type_cursor FOR
3520: SELECT distinct decode(d.line_type,-1,'1',+1,'2',+2,'3'),
3521: meaning,
3522: d.line_type
3523: FROM gme_batch_header h,
3524: gme_material_details d,
3525: gme_batch_step_items si,
3526: gme_batch_steps s,
3527: gem_lookups lkup

Line 3550: FROM gme_batch_header h,

3546: OPEN x_line_type_cursor FOR
3547: SELECT distinct decode(d.line_type,-1,'1',+1,'2',+2,'3'),
3548: meaning,
3549: d.line_type
3550: FROM gme_batch_header h,
3551: gme_material_details d,
3552: gem_lookups lkup
3553: WHERE h.organization_id = p_organization_id
3554: AND h.batch_id = p_batch_id

Line 3617: FROM gme_batch_header h,

3613: OPEN x_line_type_cursor FOR
3614: SELECT distinct decode(d.line_type,-1,'1',+1,'2',+2,'3'),
3615: meaning,
3616: d.line_type
3617: FROM gme_batch_header h,
3618: gme_material_details d,
3619: gme_batch_step_items si,
3620: gme_batch_steps s,
3621: gem_lookups lkup

Line 3645: FROM gme_batch_header h,

3641: OPEN x_line_type_cursor FOR
3642: SELECT distinct decode(d.line_type,-1,'1',+1,'2',+2,'3'),
3643: meaning,
3644: d.line_type
3645: FROM gme_batch_header h,
3646: gme_material_details d,
3647: gem_lookups lkup
3648: WHERE h.organization_id = p_organization_id
3649: AND h.batch_id = p_batch_id

Line 3843: FROM gme_batch_header gbh, gme_batch_steps gbs, gmd_operations gmo, gem_lookups glk

3839: TO_NUMBER(NULL) act_step_qty, gbs.step_qty_um,
3840: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING),
3841: ' ' act_start_date,
3842: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING) plan_comlt_date
3843: FROM gme_batch_header gbh, gme_batch_steps gbs, gmd_operations gmo, gem_lookups glk
3844: WHERE gbh.batch_id = p_batch_id
3845: AND gbh.batch_type = 0
3846: AND gbh.batch_id = gbs.batch_id
3847: AND gbs.step_status = 1

Line 3874: FROM gme_batch_header gbh, gme_batch_steps gbs, gmd_operations gmo, gem_lookups glk

3870: TO_NUMBER(NULL) act_step_qty, gbs.step_qty_um,
3871: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING),
3872: DECODE(gbs.actual_start_date,NULL,' ',TO_CHAR(gbs.actual_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING)) act_start_date,
3873: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING) plan_comlt_date
3874: FROM gme_batch_header gbh, gme_batch_steps gbs, gmd_operations gmo, gem_lookups glk
3875: WHERE gbh.batch_id = p_batch_id
3876: AND gbh.batch_type = 0
3877: AND gbh.batch_id = gbs.batch_id
3878: AND gbs.step_status IN (1,2)

Line 3915: FROM gme_batch_header h,

3911: , ROUND(DECODE(s.step_status, 2, r.plan_rsrc_qty, 3, r.actual_rsrc_qty),2)
3912: , r.resource_qty_um
3913: , ROUND(DECODE(s.step_status, 2, r.plan_rsrc_usage, 3, r.actual_rsrc_usage),2)
3914: , r.usage_um
3915: FROM gme_batch_header h,
3916: gme_batch_steps s,
3917: gme_batch_step_activities a,
3918: gme_batch_step_resources r,
3919: gmp_resource_instances i,