View: INVFV_ONHAND_BALANCES

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.INVFV_ONHAND_BALANCES

View Text

SELECT MOQ.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI' /* KEY FLEXFIELD */
, MOQ.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOU.NAME
, MOQ.DATE_RECEIVED
, MOQ.TRANSACTION_QUANTITY
, MOQ.SUBINVENTORY_CODE
, MOQ.REVISION
, MOQ.LOCATOR_ID
, '_KF:INV:MTLL:MIL' /* KEY FLEXFIELD */
, MOQ.CREATE_TRANSACTION_ID
, MOQ.UPDATE_TRANSACTION_ID
, MOQ.LOT_NUMBER
, MOQ.CREATED_BY
, MOQ.CREATION_DATE
, MOQ.LAST_UPDATED_BY
, MOQ.LAST_UPDATE_DATE
FROM MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HOU
, MTL_SYSTEM_ITEMS MSI
, MTL_ITEM_LOCATIONS MIL
, MTL_ONHAND_QUANTITIES MOQ
WHERE MSI.INVENTORY_ITEM_ID = MOQ.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MOQ.ORGANIZATION_ID
AND MIL.INVENTORY_LOCATION_ID (+) = MOQ.LOCATOR_ID
AND MIL.ORGANIZATION_ID (+) = MOQ.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = MOQ.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MOQ.ORGANIZATION_ID
AND '_SEC:MOQ.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns