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_DETAIL_UTIL_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 1447: MTL_ONHAND_QUANTITIES_DETAIL moq

1443: ,sum(moq.primary_transaction_quantity) primary_quantity
1444: ,moq.project_id
1445: ,moq.task_id
1446: FROM
1447: MTL_ONHAND_QUANTITIES_DETAIL moq
1448: WHERE
1449: moq.organization_id = :organization_id
1450: AND moq.inventory_item_id = :inventory_item_id
1451: GROUP BY

Line 3865: FROM mtl_onhand_quantities_detail

3861: -- Entire LPN is being allocated
3862:
3863: BEGIN
3864: SELECT status_id into l_status_id
3865: FROM mtl_onhand_quantities_detail
3866: WHERE organization_id = p_organization_id
3867: AND inventory_item_id = p_inventory_item_id
3868: AND subinventory_code = p_subinventory_code
3869: AND locator_id = p_locator_id

Line 3911: SELECT 1 FROM mtl_onhand_quantities_detail moqd

3907:
3908: BEGIN
3909:
3910: SELECT 'Y' into l_status_return FROM DUAL WHERE EXISTS(
3911: SELECT 1 FROM mtl_onhand_quantities_detail moqd
3912: WHERE moqd.organization_id = p_organization_id
3913: AND moqd.inventory_item_id = p_inventory_item_id
3914: AND moqd.subinventory_code = p_subinventory_code
3915: AND nvl(moqd.locator_id,-999) = nvl(p_locator_id,-999)