RCS_ORG_DEFINITIONS_LW_V

Details

• Schema: FUSION

• Object owner: RCS

• Object type: VIEW

Columns

Name

ORGANIZATION_ID USER_DEFINITION_ENABLE_DATE DISABLE_DATE ORGANIZATION_CODE ORGANIZATION_NAME INVENTORY_ENABLED_FLAG BUSINESS_UNIT_ID LEGAL_ENTITY LOCATION_ID INVENTORY_FLAG MASTER_ORGANIZATION_ID PROFIT_CENTER_BU_ID MFG_PLANT_FLAG CONTRACT_MFG_FLAG SUPPLIER_ID SUPPLIER_SITE_ID EAM_ENABLED_FLAG ITEM_GROUPING_CODE ITEM_DEFINITION_ORG_ID GROUPING_JOB_STATUS GROUPING_JOB_ID PROJECT_REFERENCE_ENABLED TRACK_COUNTRY_OF_ORIGIN_FLAG FA_BOOK_TYPE_CODE ALLOW_ITEM_SUBSTITUTIONS TIMEZONE_CODE WMS_WITH_MFG_ALM

Query

SQL_Statement

SELECT HOU.ORGANIZATION_ID ORGANIZATION_ID, HOU.effective_start_date USER_DEFINITION_ENABLE_DATE, HOU.effective_end_date DISABLE_DATE , MP.ORGANIZATION_CODE ORGANIZATION_CODE, HOU.NAME ORGANIZATION_NAME, DECODE(HOI1.STATUS, 'A', 'Y', 'N') INVENTORY_ENABLED_FLAG, MP.BUSINESS_UNIT_ID BUSINESS_UNIT_ID, MP.LEGAL_ENTITY_ID LEGAL_ENTITY, HOU.LOCATION_ID LOCATION_ID, MP.INVENTORY_FLAG INVENTORY_FLAG, MP.MASTER_ORGANIZATION_ID, MP.PROFIT_CENTER_BU_ID, MP.MFG_PLANT_FLAG, MP.CONTRACT_MFG_FLAG, MP.SUPPLIER_ID, MP.SUPPLIER_SITE_ID, MP.EAM_ENABLED_FLAG, MP.ITEM_GROUPING_CODE, MP.ITEM_DEFINITION_ORG_ID, MP.GROUPING_JOB_STATUS, MP.GROUPING_JOB_ID , MP.PROJECT_REFERENCE_ENABLED, MP.TRACK_COUNTRY_OF_ORIGIN_FLAG, MP.FA_BOOK_TYPE_CODE, MP.ALLOW_ITEM_SUBSTITUTIONS, MP.TIMEZONE_CODE, MP.WMS_WITH_MFG_ALM FROM HR_ALL_ORGANIZATION_UNITS_X HOU, HR_ORG_UNIT_CLASSIFICATIONS_X HOI1, INV_ORG_PARAMETERS MP WHERE HOI1.CLASSIFICATION_CODE = 'INV' AND HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID