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 3357: gme_pending_product_lots lo,

3353: NVL(quantity, 0),
3354: lo.pending_product_lot_id,
3355: NVL(m.locator_id,-1)
3356: FROM gme_material_details m,
3357: gme_pending_product_lots lo,
3358: wms_item_locations_kfv loc,
3359: mtl_lot_numbers mln
3360: WHERE m.batch_id = lo.batch_id
3361: AND m.material_detail_id = lo.material_detail_id

Line 3399: GME_PENDING_PRODUCT_LOTS

3395: BEGIN
3396: OPEN x_lot_num_lov FOR
3397: SELECT DISTINCT lot_number
3398: FROM
3399: GME_PENDING_PRODUCT_LOTS
3400: WHERE
3401: batch_id = p_batch_id AND
3402: material_detail_id = NVL(p_material_detail_id, material_detail_id) AND
3403: lot_number LIKE (p_lot_number)

Line 3423: GME_PENDING_PRODUCT_LOTS

3419: OPEN x_lot_num_lov FOR
3420: SELECT DISTINCT lot_number, quantity, NVL(secondary_quantity,0),
3421: pending_product_lot_id
3422: FROM
3423: GME_PENDING_PRODUCT_LOTS
3424: WHERE
3425: batch_id = p_batch_id AND
3426: material_detail_id = NVL(p_material_detail_id, material_detail_id) AND
3427: lot_number LIKE (p_lot_number) AND

Line 3856: FROM gme_pending_product_lots

3852: IS
3853: BEGIN
3854: OPEN x_revision_cursor FOR
3855: SELECT DISTINCT revision
3856: FROM gme_pending_product_lots
3857: WHERE batch_id = p_batch_id
3858: AND material_detail_id = p_material_detail_id
3859: AND revision LIKE (p_revision)
3860: ORDER BY revision;