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_PENDING_PRODUCT_LOTS

Line 3273: gme_pending_product_lots lo,

3269: NVL(quantity, 0),
3270: lo.pending_product_lot_id,
3271: NVL(m.locator_id,-1)
3272: FROM gme_material_details m,
3273: gme_pending_product_lots lo,
3274: wms_item_locations_kfv loc,
3275: mtl_lot_numbers mln
3276: WHERE m.batch_id = lo.batch_id
3277: AND m.material_detail_id = lo.material_detail_id

Line 3315: GME_PENDING_PRODUCT_LOTS

3311: BEGIN
3312: OPEN x_lot_num_lov FOR
3313: SELECT DISTINCT lot_number
3314: FROM
3315: GME_PENDING_PRODUCT_LOTS
3316: WHERE
3317: batch_id = p_batch_id AND
3318: material_detail_id = NVL(p_material_detail_id, material_detail_id) AND
3319: lot_number LIKE (p_lot_number)

Line 3339: GME_PENDING_PRODUCT_LOTS

3335: OPEN x_lot_num_lov FOR
3336: SELECT DISTINCT lot_number, quantity, NVL(secondary_quantity,0),
3337: pending_product_lot_id
3338: FROM
3339: GME_PENDING_PRODUCT_LOTS
3340: WHERE
3341: batch_id = p_batch_id AND
3342: material_detail_id = NVL(p_material_detail_id, material_detail_id) AND
3343: lot_number LIKE (p_lot_number) AND

Line 3772: FROM gme_pending_product_lots

3768: IS
3769: BEGIN
3770: OPEN x_revision_cursor FOR
3771: SELECT DISTINCT revision
3772: FROM gme_pending_product_lots
3773: WHERE batch_id = p_batch_id
3774: AND material_detail_id = p_material_detail_id
3775: AND revision LIKE (p_revision)
3776: ORDER BY revision;