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 2845: mtl_lot_numbers mln

2841: i, TO_CHAR(mln.expiration_date, l_date_format)
2842: , mln.grade_code
2843: , mln.parent_lot_number
2844: FROM mtl_reservations mr,
2845: mtl_lot_numbers mln
2846: WHERE mr.organization_id = p_organization_id
2847: AND mr.organization_id = mln.organization_id
2848: AND mr.inventory_item_id = p_item_id
2849: AND mr.inventory_item_id = mln.inventory_item_id

Line 2868: mtl_lot_numbers mln

2864: i, TO_CHAR(mln.expiration_date, l_date_format)
2865: , mln.grade_code
2866: , mln.parent_lot_number
2867: FROM mtl_reservations mr,
2868: mtl_lot_numbers mln
2869: WHERE mr.organization_id = p_organization_id
2870: AND mr.organization_id = mln.organization_id
2871: AND mr.inventory_item_id = p_item_id
2872: AND mr.inventory_item_id = mln.inventory_item_id

Line 2983: FROM mtl_lot_numbers mln

2979: SELECT DISTINCT mln.lot_number
2980: , TO_CHAR(mln.expiration_date, l_date_format)
2981: , mln.grade_code
2982: , mln.parent_lot_number
2983: FROM mtl_lot_numbers mln
2984: WHERE mln.organization_id = p_organization_id
2985: AND mln.inventory_item_id = p_item_id
2986: AND mln.lot_number LIKE (p_lot_number)
2987: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moqd

Line 2999: FROM mtl_lot_numbers mln

2995: SELECT DISTINCT mln.lot_number
2996: , TO_CHAR(mln.expiration_date, l_date_format)
2997: , mln.grade_code
2998: , mln.parent_lot_number
2999: FROM mtl_lot_numbers mln
3000: WHERE mln.organization_id = p_organization_id
3001: AND mln.inventory_item_id = p_item_id
3002: AND mln.lot_number LIKE (p_lot_number)
3003: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moqd

Line 3059: FROM mtl_lot_numbers mln

3055: SELECT DISTINCT mln.lot_number
3056: , TO_CHAR(mln.expiration_date, l_date_format)
3057: , mln.grade_code
3058: , mln.parent_lot_number
3059: FROM mtl_lot_numbers mln
3060: WHERE mln.organization_id = p_organization_id
3061: AND mln.inventory_item_id = p_item_id
3062: AND mln.lot_number LIKE (p_lot_number)
3063: AND NVL(mln.expiration_date,SYSDATE+1) > SYSDATE --Bug#5092198

Line 3076: FROM mtl_lot_numbers mln

3072: SELECT DISTINCT mln.lot_number
3073: , TO_CHAR(mln.expiration_date, l_date_format)
3074: , mln.grade_code
3075: , mln.parent_lot_number
3076: FROM mtl_lot_numbers mln
3077: WHERE mln.organization_id = p_organization_id
3078: AND mln.inventory_item_id = p_item_id
3079: AND mln.lot_number LIKE (p_lot_number)
3080: AND NVL(mln.expiration_date,SYSDATE+1) > SYSDATE --Bug#5092198

Line 3132: FROM mtl_lot_numbers mln

3128: SELECT DISTINCT mln.lot_number
3129: , TO_CHAR(mln.expiration_date, l_date_format)
3130: , mln.grade_code
3131: , mln.parent_lot_number
3132: FROM mtl_lot_numbers mln
3133: WHERE mln.organization_id = p_organization_id
3134: AND mln.inventory_item_id = p_item_id
3135: AND mln.lot_number LIKE (p_lot_number)
3136: AND NVl(mln.expiration_date,SYSDATE+1) > SYSDATE; --Bug#5092198

Line 3275: mtl_lot_numbers mln

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

Line 3377: FROM mtl_lot_numbers l, gme_material_details d

3373: BEGIN
3374:
3375: OPEN x_lot_num_lov FOR
3376: SELECT lot_number
3377: FROM mtl_lot_numbers l, gme_material_details d
3378: WHERE l.inventory_item_id = d.inventory_item_id
3379: AND l.organization_id = d.organization_id
3380: AND d.material_detail_id = p_material_detail_id
3381: AND l.lot_number LIKE (p_lot_number)

Line 3384: FROM mtl_lot_numbers l, gme_material_details d

3380: AND d.material_detail_id = p_material_detail_id
3381: AND l.lot_number LIKE (p_lot_number)
3382: UNION
3383: SELECT parent_lot_number
3384: FROM mtl_lot_numbers l, gme_material_details d
3385: WHERE l.inventory_item_id = d.inventory_item_id
3386: AND l.organization_id = d.organization_id
3387: AND d.material_detail_id = p_material_detail_id
3388: AND l.parent_lot_number LIKE (p_lot_number)