VIEW: APPS.INVFV_ONHAND_BALANCES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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