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 157: gem_lookups lkup

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

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

Line 210: gem_lookups lkup

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

Line 236: gem_lookups lkup

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)
240: --- 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 295: gem_lookups lkup

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

Line 328: gem_lookups lkup

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

Line 3527: gem_lookups lkup

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
3528: WHERE h.organization_id = p_organization_id
3529: AND h.batch_id = p_batch_id
3530: AND h.batch_id = d.batch_id
3531: AND d.batch_id = si.batch_id

Line 3552: gem_lookups lkup

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
3555: AND h.batch_id = d.batch_id
3556: AND h.batch_type = 0

Line 3621: gem_lookups lkup

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
3622: WHERE h.organization_id = p_organization_id
3623: AND h.batch_id = p_batch_id
3624: AND h.batch_id = d.batch_id
3625: AND d.batch_id = si.batch_id

Line 3647: gem_lookups lkup

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
3650: AND h.batch_id = d.batch_id
3651: AND h.batch_type = 0

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)