View: SO_ITEM_WAREHOUSES_V

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	APPS.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