View: MSD_ORGANIZATION_DEFINITIONS

Product:	MSD - Demand Planning
Description:	This view show organization definitions
Implementation/DBA Data:	APPS.MSD_ORGANIZATION_DEFINITIONS

View Text

SELECT HOU.ORGANIZATION_ID ORGANIZATION_ID
, HOU.BUSINESS_GROUP_ID
, HOU.DATE_FROM USER_DEFINITION_ENABLE_DATE
, HOU.DATE_TO DISABLE_DATE
, MP.ORGANIZATION_CODE ORGANIZATION_CODE
, HOU.NAME ORGANIZATION_NAME
, GSOB.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, GSOB.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, HOI1.ORG_INFORMATION2 INVENTORY_ENABLED_FLAG
, DECODE(FPG.MULTI_ORG_FLAG
, 'Y'
, TO_NUMBER(HOI2.ORG_INFORMATION3)
, NULL) OPERATING_UNIT
, DECODE(HOI2.ORG_INFORMATION_CONTEXT
, 'ACCOUNTING INFORMATION'
, TO_NUMBER(HOI2.ORG_INFORMATION2)
, NULL) LEGAL_ENTITY
, MP.CALENDAR_CODE
FROM HR_ALL_ORGANIZATION_UNITS HOU
, HR_ORGANIZATION_INFORMATION HOI1
, HR_ORGANIZATION_INFORMATION HOI2
, MTL_PARAMETERS MP
, GL_SETS_OF_BOOKS GSOB
, FND_PRODUCT_GROUPS FPG
WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MP.PROCESS_ENABLED_FLAG = 'N'
AND HOI1.ORG_INFORMATION1 = 'INV'
AND HOI1.ORG_INFORMATION2 = 'Y'
AND (HOI1.ORG_INFORMATION_CONTEXT || '') = 'CLASS'
AND (HOI2.ORG_INFORMATION_CONTEXT || '') = 'ACCOUNTING INFORMATION'
AND HOI2.ORG_INFORMATION1 = TO_CHAR(GSOB.SET_OF_BOOKS_ID)

Columns