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 1580: MTL_ONHAND_QUANTITIES_DETAIL moq

1576: ,sum(moq.primary_transaction_quantity) primary_quantity
1577: ,moq.project_id
1578: ,moq.task_id
1579: FROM
1580: MTL_ONHAND_QUANTITIES_DETAIL moq
1581: WHERE
1582: moq.organization_id = :organization_id
1583: AND moq.inventory_item_id = :inventory_item_id
1584: GROUP BY

Line 4284: FROM mtl_onhand_quantities_detail

4280: -- Entire LPN is being allocated
4281:
4282: BEGIN
4283: SELECT status_id into l_status_id
4284: FROM mtl_onhand_quantities_detail
4285: WHERE organization_id = p_organization_id
4286: AND inventory_item_id = p_inventory_item_id
4287: AND subinventory_code = p_subinventory_code
4288: AND locator_id = p_locator_id

Line 4330: SELECT 1 FROM mtl_onhand_quantities_detail moqd

4326:
4327: BEGIN
4328:
4329: SELECT 'Y' into l_status_return FROM DUAL WHERE EXISTS(
4330: SELECT 1 FROM mtl_onhand_quantities_detail moqd
4331: WHERE moqd.organization_id = p_organization_id
4332: AND moqd.inventory_item_id = p_inventory_item_id
4333: AND moqd.subinventory_code = p_subinventory_code
4334: AND nvl(moqd.locator_id,-999) = nvl(p_locator_id,-999)