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

Line 4964: from mtl_onhand_quantities_detail moqd,

4960: WHERE TRANSACTION_INTERFACE_ID = p_intid
4961: AND EXISTS
4962: (
4963: select 'comingling exists'
4964: from mtl_onhand_quantities_detail moqd,
4965: mtl_transactions_interface mti
4966: WHERE mti.TRANSACTION_INTERFACE_ID = p_intid
4967: AND PROCESS_FLAG = 1
4968: AND moqd.organization_id = mti.organization_id

Line 4995: from mtl_onhand_quantities_detail moqd,

4991: AND PROCESS_FLAG = 1
4992: AND EXISTS
4993: (
4994: select 'comingling exists'
4995: from mtl_onhand_quantities_detail moqd,
4996: mtl_transaction_lots_interface mtli
4997: WHERE moqd.organization_id = mti.organization_id
4998: AND moqd.inventory_item_id = mti.inventory_item_id
4999: and moqd.subinventory_code = mti.subinventory_code

Line 15449: FROM mtl_onhand_quantities_detail

15445: ELSE
15446: /*Bug#7139549 check if the lot exists but it is a pending product lot */
15447:
15448: SELECT count(1) into l_lot_onhand
15449: FROM mtl_onhand_quantities_detail
15450: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
15451: AND ORGANIZATION_ID = p_organization_id
15452: AND lot_number = p_lot_number
15453: AND PRIMARY_TRANSACTION_QUANTITY > 0