[Home] [Help]
View: SO_ITEM_WAREHOUSES_V
View Text
SELECT MTP.ORGANIZATION_CODE
, HRU.NAME
, HRU.ORGANIZATION_ID
, MSI.INVENTORY_ITEM_ID
, MSI.CUSTOMER_ORDER_ENABLED_FLAG
, MSI.RETURNABLE_FLAG
FROM MTL_PARAMETERS MTP
, HR_ORGANIZATION_UNITS HRU
, MTL_SYSTEM_ITEMS MSI
WHERE HRU.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND HRU.ORGANIZATION_ID = MTP.ORGANIZATION_ID
AND TRUNC(SYSDATE) >= HRU.DATE_FROM
AND TRUNC(SYSDATE) <= NVL(DATE_TO
, TRUNC(SYSDATE))
Columns
Name |
ORGANIZATION_CODE |
ORGANIZATION_NAME |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |
CUSTOMER_ORDER_ENABLED_FLAG |
RETURNABLE_FLAG |