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 MTL_LOT_NUMBERS

Line 2872: mtl_lot_numbers mln

2868: i, TO_CHAR(mln.expiration_date, l_date_format)
2869: , mln.grade_code
2870: , mln.parent_lot_number
2871: FROM mtl_reservations mr,
2872: mtl_lot_numbers mln
2873: WHERE mr.organization_id = p_organization_id
2874: AND mr.organization_id = mln.organization_id
2875: AND mr.inventory_item_id = p_item_id
2876: AND mr.inventory_item_id = mln.inventory_item_id

Line 2895: mtl_lot_numbers mln

2891: i, TO_CHAR(mln.expiration_date, l_date_format)
2892: , mln.grade_code
2893: , mln.parent_lot_number
2894: FROM mtl_reservations mr,
2895: mtl_lot_numbers mln
2896: WHERE mr.organization_id = p_organization_id
2897: AND mr.organization_id = mln.organization_id
2898: AND mr.inventory_item_id = p_item_id
2899: AND mr.inventory_item_id = mln.inventory_item_id

Line 3010: FROM mtl_lot_numbers mln

3006: SELECT DISTINCT mln.lot_number
3007: , TO_CHAR(mln.expiration_date, l_date_format)
3008: , mln.grade_code
3009: , mln.parent_lot_number
3010: FROM mtl_lot_numbers mln
3011: WHERE mln.organization_id = p_organization_id
3012: AND mln.inventory_item_id = p_item_id
3013: AND mln.lot_number LIKE (p_lot_number)
3014: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moqd

Line 3026: FROM mtl_lot_numbers mln

3022: SELECT DISTINCT mln.lot_number
3023: , TO_CHAR(mln.expiration_date, l_date_format)
3024: , mln.grade_code
3025: , mln.parent_lot_number
3026: FROM mtl_lot_numbers mln
3027: WHERE mln.organization_id = p_organization_id
3028: AND mln.inventory_item_id = p_item_id
3029: AND mln.lot_number LIKE (p_lot_number)
3030: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moqd

Line 3090: FROM mtl_lot_numbers mln

3086: SELECT DISTINCT mln.lot_number
3087: , TO_CHAR(mln.expiration_date, l_date_format)
3088: , mln.grade_code
3089: , mln.parent_lot_number
3090: FROM mtl_lot_numbers mln
3091: WHERE mln.organization_id = p_organization_id
3092: AND mln.inventory_item_id = p_item_id
3093: AND mln.lot_number LIKE (p_lot_number)
3094: AND NVL(mln.expiration_date,SYSDATE+1) > SYSDATE --Bug#5092198

Line 3122: FROM mtl_lot_numbers mln

3118: SELECT DISTINCT mln.lot_number
3119: , TO_CHAR(mln.expiration_date, l_date_format)
3120: , mln.grade_code
3121: , mln.parent_lot_number
3122: FROM mtl_lot_numbers mln
3123: WHERE mln.organization_id = p_organization_id
3124: AND mln.inventory_item_id = p_item_id
3125: AND mln.lot_number LIKE (p_lot_number)
3126: AND NVL(mln.expiration_date,SYSDATE+1) > SYSDATE --Bug#5092198

Line 3216: FROM mtl_lot_numbers mln

3212: SELECT DISTINCT mln.lot_number
3213: , TO_CHAR(mln.expiration_date, l_date_format)
3214: , mln.grade_code
3215: , mln.parent_lot_number
3216: FROM mtl_lot_numbers mln
3217: WHERE mln.organization_id = p_organization_id
3218: AND mln.inventory_item_id = p_item_id
3219: AND mln.lot_number LIKE (p_lot_number)
3220: AND NVl(mln.expiration_date,SYSDATE+1) > SYSDATE; --Bug#5092198

Line 3359: mtl_lot_numbers mln

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
3362: AND m.locator_id = loc.inventory_location_id(+)
3363: AND m.inventory_item_id = mln.inventory_item_id

Line 3461: FROM mtl_lot_numbers l, gme_material_details d

3457: BEGIN
3458:
3459: OPEN x_lot_num_lov FOR
3460: SELECT lot_number
3461: FROM mtl_lot_numbers l, gme_material_details d
3462: WHERE l.inventory_item_id = d.inventory_item_id
3463: AND l.organization_id = d.organization_id
3464: AND d.material_detail_id = p_material_detail_id
3465: AND l.lot_number LIKE (p_lot_number)

Line 3468: FROM mtl_lot_numbers l, gme_material_details d

3464: AND d.material_detail_id = p_material_detail_id
3465: AND l.lot_number LIKE (p_lot_number)
3466: UNION
3467: SELECT parent_lot_number
3468: FROM mtl_lot_numbers l, gme_material_details d
3469: WHERE l.inventory_item_id = d.inventory_item_id
3470: AND l.organization_id = d.organization_id
3471: AND d.material_detail_id = p_material_detail_id
3472: AND l.parent_lot_number LIKE (p_lot_number)