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 GEM_LOOKUPS

Line 184: gem_lookups lkup

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 in (1,2)
188: --- Bug 5236930 AND batch_no LIKE LTRIM(RTRIM('%'||p_batch_no||'%'))

Line 211: gem_lookups lkup

207: ,batch_id
208: ,NVL(formula_id,0)
209: ,NVL(routing_id,0)
210: FROM gme_batch_header b,
211: gem_lookups lkup
212: WHERE organization_id = p_org_id
213: AND batch_type= 0
214: AND batch_status = 2
215: --- Bug 5236930 AND batch_no LIKE LTRIM(RTRIM('%'||p_batch_no||'%'))

Line 237: gem_lookups lkup

233: ,batch_id
234: ,NVL(formula_id,0)
235: ,NVL(routing_id,0)
236: FROM gme_batch_header b,
237: gem_lookups lkup
238: WHERE organization_id = p_org_id
239: AND batch_type= 0
240: AND batch_status in (2,3)
241: --- Bug 5236930 AND batch_no LIKE LTRIM(RTRIM('%'||p_batch_no||'%'))

Line 263: gem_lookups lkup

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)
267: --- Bug 5236930 AND batch_no LIKE LTRIM(RTRIM('%'||p_batch_no||'%'))

Line 290: gem_lookups lkup

286: ,batch_id
287: ,NVL(formula_id,0)
288: ,NVL(routing_id,0)
289: FROM gme_batch_header b,
290: gem_lookups lkup
291: WHERE organization_id = p_org_id
292: AND batch_type= 0
293: AND batch_status in (2,3)
294: --- Bug 5236930 AND batch_no LIKE LTRIM(RTRIM('%'||p_batch_no||'%'))

Line 322: gem_lookups lkup

318: ,batch_id
319: ,NVL(formula_id,0)
320: ,NVL(routing_id,0)
321: FROM gme_batch_header h,
322: gem_lookups lkup
323: WHERE organization_id = p_org_id
324: AND batch_type= 0
325: AND batch_status = 3
326: --- Bug 5236930 AND batch_no LIKE LTRIM(RTRIM('%'||p_batch_no||'%'))

Line 355: gem_lookups lkup

351: ,batch_id
352: ,NVL(formula_id,0)
353: ,NVL(routing_id,0)
354: FROM gme_batch_header b,
355: gem_lookups lkup
356: WHERE organization_id = p_org_id
357: AND batch_type= 0
358: AND batch_status in (1,2)
359: --- Bug 5236930 AND batch_no LIKE LTRIM(RTRIM('%'||p_batch_no||'%'))

Line 3611: gem_lookups lkup

3607: FROM gme_batch_header h,
3608: gme_material_details d,
3609: gme_batch_step_items si,
3610: gme_batch_steps s,
3611: gem_lookups lkup
3612: WHERE h.organization_id = p_organization_id
3613: AND h.batch_id = p_batch_id
3614: AND h.batch_id = d.batch_id
3615: AND d.batch_id = si.batch_id

Line 3636: gem_lookups lkup

3632: meaning,
3633: d.line_type
3634: FROM gme_batch_header h,
3635: gme_material_details d,
3636: gem_lookups lkup
3637: WHERE h.organization_id = p_organization_id
3638: AND h.batch_id = p_batch_id
3639: AND h.batch_id = d.batch_id
3640: AND h.batch_type = 0

Line 3705: gem_lookups lkup

3701: FROM gme_batch_header h,
3702: gme_material_details d,
3703: gme_batch_step_items si,
3704: gme_batch_steps s,
3705: gem_lookups lkup
3706: WHERE h.organization_id = p_organization_id
3707: AND h.batch_id = p_batch_id
3708: AND h.batch_id = d.batch_id
3709: AND d.batch_id = si.batch_id

Line 3731: gem_lookups lkup

3727: meaning,
3728: d.line_type
3729: FROM gme_batch_header h,
3730: gme_material_details d,
3731: gem_lookups lkup
3732: WHERE h.organization_id = p_organization_id
3733: AND h.batch_id = p_batch_id
3734: AND h.batch_id = d.batch_id
3735: AND h.batch_type = 0

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

3923: TO_NUMBER(NULL) act_step_qty, gbs.step_qty_um,
3924: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING),
3925: ' ' act_start_date,
3926: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING) plan_comlt_date
3927: FROM gme_batch_header gbh, gme_batch_steps gbs, gmd_operations gmo, gem_lookups glk
3928: WHERE gbh.batch_id = p_batch_id
3929: AND gbh.batch_type = 0
3930: AND gbh.batch_id = gbs.batch_id
3931: AND gbs.step_status = 1

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

3954: TO_NUMBER(NULL) act_step_qty, gbs.step_qty_um,
3955: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING),
3956: 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,
3957: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING) plan_comlt_date
3958: FROM gme_batch_header gbh, gme_batch_steps gbs, gmd_operations gmo, gem_lookups glk
3959: WHERE gbh.batch_id = p_batch_id
3960: AND gbh.batch_type = 0
3961: AND gbh.batch_id = gbs.batch_id
3962: AND gbs.step_status IN (1,2)