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.WMS_TASK_DISPATCH_GEN dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 14223: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc

14219: ELSE
14220: -- It however remains same for LPNs
14221: SELECT COUNT(*)
14222: INTO x_lot_num_lov_count
14223: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc
14224: WHERE mln.organization_id = p_organization_id
14225: AND mln.inventory_item_id = p_item_id
14226: AND mln.lot_number LIKE(p_lot_number || '%')
14227: AND moq.lot_number = mln.lot_number

Line 14261: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt

14257: IF (p_lpn_id IS NULL
14258: OR p_lpn_id = 0) THEN
14259: SELECT COUNT(*)
14260: INTO x_lot_num_lov_count
14261: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt
14262: WHERE mln.organization_id = p_organization_id
14263: AND mln.inventory_item_id = p_item_id
14264: AND mln.lot_number LIKE(p_lot_number || '%')
14265: AND moq.lot_number = mln.lot_number

Line 14290: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc

14286: ) = 'Y';
14287: ELSE
14288: SELECT COUNT(*)
14289: INTO x_lot_num_lov_count
14290: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc
14291: WHERE mln.organization_id = p_organization_id
14292: AND mln.inventory_item_id = p_item_id
14293: AND mln.lot_number LIKE(p_lot_number || '%')
14294: AND moq.lot_number = mln.lot_number