MSC_DIM_ORGANIZATION_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID PARENT_ORG_ID ORGANIZATION_CODE NAME DEST_ORGANIZATION_CODE DESCRIPTION PARENT_ID SR_INSTANCE_ID FULFILLMENT_INSTANCE_FLAG DROP_SHIP_VAL_ORG_FLAG OPERATING_UNIT_NAME BUSINESS_UNIT_NAME LEGAL_ENTITY_NAME REFRESH_NUMBER SUBINV_PLANNING_ENABLED PAST_DUE_SO_DAYS PAST_DUE_FORECAST_DAYS PAST_DUE_SUPPLY_DAYS COLLECT_NONNETTABLE_PAR_SUBINV

Query

SQL_Statement

SELECT MP.ORGANIZATION_ID ID , MP.ORGANIZATION_ID PARENT_ORG_ID, IO.SR_ORGANIZATION_CODE ORGANIZATION_CODE, MP.ORGANIZATION_NAME NAME , MP.ORGANIZATION_CODE DEST_ORGANIZATION_CODE, MP.ORGANIZATION_ID ||'-'|| ORGANIZATION_NAME DESCRIPTION , NVL(CASE AI.APPS_VER WHEN 2 THEN MP.BUSINESS_UNIT_ID ELSE MP.OPERATING_UNIT_ID END ,-1) PARENT_ID , IO.SR_INSTANCE_ID SR_INSTANCE_ID , IO.FULFILLMENT_INSTANCE_FLAG, IO.DROP_SHIP_VAL_ORG_FLAG, MP.OPERATING_UNIT_NAME OPERATING_UNIT_NAME, MP.BUSINESS_UNIT_NAME BUSINESS_UNIT_NAME , MP.LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME , MP.REFRESH_NUMBER, MP.SUBINV_PLANNING_ENABLED SUBINV_PLANNING_ENABLED, MP.PAST_DUE_SO_DAYS PAST_DUE_SO_DAYS, MP.PAST_DUE_FORECAST_DAYS PAST_DUE_FORECAST_DAYS, MP.PAST_DUE_SUPPLY_DAYS PAST_DUE_SUPPLY_DAYS, MP.COLLECT_NONNETTABLE_PAR_SUBINV COLLECT_NONNETTABLE_PAR_SUBINV FROM MSC_PARAMETERS MP, MSC_APPS_INSTANCES AI, MSC_INSTANCE_ORGS IO WHERE AI.INSTANCE_ID = IO.SR_INSTANCE_ID AND MP.ORGANIZATION_ID = IO.ORGANIZATION_ID AND ( ( IO.FULFILLMENT_INSTANCE_FLAG = 1 ) OR ( mp.modeled_supplier_id is not null AND mp.MODELED_SUPPLIER_SITE_ID is not null AND io.INVENTORY_FLAG='N' ) ) UNION SELECT MP.ORGANIZATION_ID ID , MP.ORGANIZATION_ID PARENT_ORG_ID, IO.SR_ORGANIZATION_CODE ORGANIZATION_CODE, MP.ORGANIZATION_NAME NAME , MP.ORGANIZATION_CODE DEST_ORGANIZATION_CODE, MP.ORGANIZATION_ID ||'-'||ORGANIZATION_NAME DESCRIPTION , nvl(CASE AI.APPS_VER WHEN 2 THEN MP.BUSINESS_UNIT_ID ELSE MP.OPERATING_UNIT_ID END ,-1) PARENT_ID , IO.SR_INSTANCE_ID SR_INSTANCE_ID , IO.FULFILLMENT_INSTANCE_FLAG, IO.DROP_SHIP_VAL_ORG_FLAG, MP.OPERATING_UNIT_NAME OPERATING_UNIT_NAME, MP.BUSINESS_UNIT_NAME BUSINESS_UNIT_NAME , MP.LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME , MP.REFRESH_NUMBER, MP.SUBINV_PLANNING_ENABLED SUBINV_PLANNING_ENABLED, MP.PAST_DUE_SO_DAYS PAST_DUE_SO_DAYS, MP.PAST_DUE_FORECAST_DAYS PAST_DUE_FORECAST_DAYS, MP.PAST_DUE_SUPPLY_DAYS PAST_DUE_SUPPLY_DAYS, MP.COLLECT_NONNETTABLE_PAR_SUBINV COLLECT_NONNETTABLE_PAR_SUBINV FROM MSC_PARAMETERS MP, MSC_APPS_INSTANCES AI, MSC_INSTANCE_ORGS IO WHERE AI.INSTANCE_ID = IO.SR_INSTANCE_ID AND MP.ORGANIZATION_ID = IO.ORGANIZATION_ID AND IO.DROP_SHIP_VAL_ORG_FLAG = 1 union SELECT MOSI.SUB_INVENTORY_ID ID, MOSI.ORGANIZATION_ID PARENT_ORG_ID, IO.SR_ORGANIZATION_CODE||':'||MOSI.SUB_INVENTORY_CODE ORGANIZATION_CODE, MOSI.SUB_INVENTORY_CODE NAME , CASE AI.APPS_VER WHEN 3 THEN AI.INSTANCE_CODE||':'||IO.SR_ORGANIZATION_CODE||':'||MOSI.SUB_INVENTORY_CODE ELSE IO.SR_ORGANIZATION_CODE||':'||MOSI.SUB_INVENTORY_CODE END DEST_ORGANIZATION_CODE, MOSI.SUB_INVENTORY_ID ||'-'||MOSI.SUB_INVENTORY_CODE DESCRIPTION , nvl(CASE AI.APPS_VER WHEN 2 THEN MP.BUSINESS_UNIT_ID ELSE MP.OPERATING_UNIT_ID END ,-1) PARENT_ID , IO.SR_INSTANCE_ID SR_INSTANCE_ID , IO.FULFILLMENT_INSTANCE_FLAG, IO.DROP_SHIP_VAL_ORG_FLAG, MP.OPERATING_UNIT_NAME OPERATING_UNIT_NAME, MP.BUSINESS_UNIT_NAME BUSINESS_UNIT_NAME , MP.LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME , MP.REFRESH_NUMBER, MP.SUBINV_PLANNING_ENABLED SUBINV_PLANNING_ENABLED, MP.PAST_DUE_SO_DAYS PAST_DUE_SO_DAYS, MP.PAST_DUE_FORECAST_DAYS PAST_DUE_FORECAST_DAYS, MP.PAST_DUE_SUPPLY_DAYS PAST_DUE_SUPPLY_DAYS, MP.COLLECT_NONNETTABLE_PAR_SUBINV COLLECT_NONNETTABLE_PAR_SUBINV FROM MSC_PARAMETERS MP, MSC_APPS_INSTANCES AI, MSC_INSTANCE_ORGS IO, MSC_ORG_SUB_INVENTORIES MOSI WHERE AI.INSTANCE_ID = IO.SR_INSTANCE_ID AND MP.ORGANIZATION_ID = IO.ORGANIZATION_ID AND MOSI.ORGANIZATION_ID=MP.ORGANIZATION_ID AND MP.SUBINV_PLANNING_ENABLED=1