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

Line 1309: mtl_onhand_quantities_detail moq

1305: v_revision VARCHAR2) is
1306: select moq.lot_number,
1307: min(mln.expiration_date)
1308: from mtl_lot_numbers mln,
1309: mtl_onhand_quantities_detail moq
1310: where moq.inventory_item_id = v_itemID
1311: and moq.organization_id = p_orgID
1312: and moq.subinventory_code = v_supplySubinv
1313: and nvl(moq.locator_id, -1) = nvl(v_supplyLocID, -1)

Line 1329: mtl_onhand_quantities_detail moq

1325: v_revision VARCHAR2) is
1326: select moq.lot_number,
1327: min(mln.expiration_date)
1328: from mtl_lot_numbers mln,
1329: mtl_onhand_quantities_detail moq
1330: where moq.inventory_item_id = v_itemID
1331: and moq.organization_id = p_orgID
1332: and moq.subinventory_code = v_supplySubinv
1333: and nvl(moq.locator_id, -1) = nvl(v_supplyLocID, -1)

Line 1353: mtl_onhand_quantities_detail moq

1349: v_revision VARCHAR2) is
1350: select tln.lot_number
1351: from mtl_transaction_lot_numbers tln ,
1352: mtl_lot_numbers mln ,
1353: mtl_onhand_quantities_detail moq
1354: where tln.transaction_date =
1355: ( select max(transaction_date)
1356: from mtl_material_transactions
1357: where organization_id = p_OrgID