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_ONHAND_QUANTITIES_DETAIL

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

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
2988: WHERE moqd.lot_number = mln.lot_number
2989: AND moqd.inventory_item_id = mln.inventory_item_id
2990: AND moqd.organization_id = mln.organization_id);
2991:

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

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
3004: WHERE moqd.lot_number = mln.lot_number
3005: AND moqd.inventory_item_id = mln.inventory_item_id
3006: AND moqd.organization_id = mln.organization_id
3007: AND moqd.subinventory_code = p_subinventory_code

Line 3065: FROM mtl_onhand_quantities_detail moqd

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
3064: AND EXISTS (SELECT '1'
3065: FROM mtl_onhand_quantities_detail moqd
3066: WHERE moqd.lot_number = mln.lot_number
3067: AND moqd.inventory_item_id = mln.inventory_item_id
3068: AND moqd.organization_id = mln.organization_id
3069: AND (p_revision IS NULL OR revision = p_revision)); --Bug#5867209

Line 3082: FROM mtl_onhand_quantities_detail moqd

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
3081: AND EXISTS (SELECT '1'
3082: FROM mtl_onhand_quantities_detail moqd
3083: WHERE moqd.lot_number = mln.lot_number
3084: AND moqd.inventory_item_id = mln.inventory_item_id
3085: AND moqd.organization_id = mln.organization_id
3086: AND moqd.subinventory_code = p_subinventory_code