MSC_ORGANIZATION_SUBINV_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ORGANIZATION_ID

Query

SQL_Statement
SELECT ORGANIZATION_ID FROM MSC_PARAMETERS union SELECT MOSI.SUB_INVENTORY_ID ORGANIZATION_ID FROM MSC_PARAMETERS MP, MSC_ORG_SUB_INVENTORIES MOSI WHERE MOSI.ORGANIZATION_ID=MP.ORGANIZATION_ID AND MP.SUBINV_PLANNING_ENABLED=1