Product: | INV - Inventory |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.INVFV_INVENTORY_LOCATORS |
SELECT MIL.INVENTORY_LOCATION_ID
, '_KF:INV:MTLL:MIL' /* KEYFLEX */
, MIL.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOU.NAME
, INV_PROJECT.GET_LOCATOR(MIL.INVENTORY_LOCATION_ID
, MIL.ORGANIZATION_ID)
, MIL.DESCRIPTION
, MIL.DISABLE_DATE
, MIL.PICKING_ORDER
, MIL.LOCATION_MAXIMUM_UNITS
, MIL.SUBINVENTORY_CODE
, MIL.LOCATION_WEIGHT_UOM_CODE
, MIL.MAX_WEIGHT
, MIL.VOLUME_UOM_CODE
, MIL.MAX_CUBIC_AREA
, MIL.CREATED_BY
, MIL.CREATION_DATE
, MIL.LAST_UPDATED_BY
, MIL.LAST_UPDATE_DATE
FROM MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HOU
, MTL_ITEM_LOCATIONS MIL
WHERE MP.ORGANIZATION_ID = MIL.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MIL.ORGANIZATION_ID
AND '_SEC:MIL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY