[Home] [Help]
View: AS_WAREHOUSES_ACTIVE_V
Product: | AS - Sales Foundation |
Description: | Active warehouses view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ORGDEF.ORGANIZATION_ID
, ORGDEF.ORGANIZATION_NAME
, MSI.INVENTORY_ITEM_ID
FROM ORG_ORGANIZATION_DEFINITIONS ORGDEF
, MTL_SYSTEM_ITEMS_B MSI
WHERE ORGDEF.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND SYSDATE <= NVL(ORGDEF.DISABLE_DATE
, SYSDATE)
Columns
Name |
WAREHOUSE_ID |
WAREHOUSE_NAME |
INVENTORY_ITEM_ID |