View: EDWBV_ORGA_BUSINESS_GRP_LCV

Product:	HRI - Human Resources Intelligence
Description:	EDWBV_ORGA_BUSINESS_GRP_LCV is the base view for HR Business Groups level of Organization dimension
Implementation/DBA Data:	APPS.EDWBV_ORGA_BUSINESS_GRP_LCV

View Text

SELECT TO_CHAR(BGR.ORGANIZATION_ID) || '-' || INST.INSTANCE_CODE BUSINESS_GROUP_PK
, 'ALL' ALL_FK
, BGR.NAME NAME
, BGR.NAME BUSINESS_GROUP_DP
, BGR.DATE_FROM DATE_FROM
, BGR.DATE_TO DATE_TO
, HR_GENERAL.DECODE_LOOKUP('INTL_EXTL'
, BGR.INTERNAL_EXTERNAL_FLAG) INT_EXT_FLAG
, MP.ORGANIZATION_CODE ORG_CODE
, HR_GENERAL.DECODE_LOOKUP('ORG_TYPE'
, BGR.TYPE) ORG_TYPE
, MP.PRIMARY_COST_METHOD PRIMARY_CST_MTHD
, TRT.TERRITORY_SHORT_NAME LEGISLATION
, FLX.ID_FLEX_STRUCTURE_NAME COST_ALLOCATION_FLEXFIELD
, INST.INSTANCE_CODE INSTANCE
, BGR.ORGANIZATION_ID BUSINESS_GROUP_ID
, '_DF:PER:PER_ORGANIZATION_UNITS:BGR'
, GREATEST(NVL(BGR.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))
, NVL(MP.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))) LAST_UPDATE_DATE
, BGR.CREATION_DATE CREATION_DATE
FROM HR_ALL_ORGANIZATION_UNITS BGR
, HR_ORGANIZATION_INFORMATION OI
, HR_ORGANIZATION_INFORMATION OI2
, MTL_PARAMETERS MP
, FND_TERRITORIES_VL TRT
, FND_ID_FLEX_STRUCTURES_VL FLX
, EDW_LOCAL_INSTANCE INST
WHERE BGR.ORGANIZATION_ID = OI.ORGANIZATION_ID
AND OI.ORG_INFORMATION_CONTEXT = 'CLASS'
AND OI.ORG_INFORMATION1 = 'HR_BG'
AND OI.ORG_INFORMATION2 = 'Y'
AND OI2.ORGANIZATION_ID = BGR.ORGANIZATION_ID
AND OI2.ORG_INFORMATION_CONTEXT = 'BUSINESS GROUP INFORMATION'
AND OI2.ORG_INFORMATION7 = FLX.ID_FLEX_NUM
AND FLX.APPLICATION_ID = 801
AND FLX.ID_FLEX_CODE = 'COST'
AND OI2.ORG_INFORMATION9 = TRT.TERRITORY_CODE
AND BGR.ORGANIZATION_ID = MP.ORGANIZATION_ID (+)

Columns