APPS.GME_MOBILE_LOVS dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 3014: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moqd

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
3015: WHERE moqd.lot_number = mln.lot_number
3016: AND moqd.inventory_item_id = mln.inventory_item_id
3017: AND moqd.organization_id = mln.organization_id);
3018:

Line 3030: AND exists (SELECT '1' FROM mtl_onhand_quantities_detail moqd

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
3031: WHERE moqd.lot_number = mln.lot_number
3032: AND moqd.inventory_item_id = mln.inventory_item_id
3033: AND moqd.organization_id = mln.organization_id
3034: AND moqd.subinventory_code = p_subinventory_code

Line 3110: FROM mtl_onhand_quantities_detail moqd

3106: ,mln.lot_number
3107: ,NULL
3108: ,'O') = 'Y' )
3109: AND EXISTS (SELECT '1'
3110: FROM mtl_onhand_quantities_detail moqd
3111: WHERE moqd.lot_number = mln.lot_number
3112: AND moqd.inventory_item_id = mln.inventory_item_id
3113: AND moqd.organization_id = mln.organization_id
3114: AND (p_revision IS NULL OR revision = p_revision)); --Bug#5867209

Line 3141: FROM mtl_onhand_quantities_detail moqd

3137: ,mln.lot_number
3138: ,NULL
3139: ,'A') = 'Y')
3140: AND EXISTS (SELECT '1'
3141: FROM mtl_onhand_quantities_detail moqd
3142: WHERE moqd.lot_number = mln.lot_number
3143: AND moqd.inventory_item_id = mln.inventory_item_id
3144: AND moqd.organization_id = mln.organization_id
3145: AND moqd.subinventory_code = p_subinventory_code