VIEW: APPS.CST_COST_GROUPS_V

Source

View Text - Preformatted

SELECT /* THIS VIEW IS MODIFIED FOR PAC IN 11.5 */ /* THE VIEW IS THE UNION OF TWO COST GROUP TYPES IN CST_COST_GROUPS TABLE: */ /* O COST_GROUP_TYPE OF 1 = PROJECT COST GROUP */ /* O COST_GROUP_TYPE OF 2 = ORG COST GROUP (USED FOR PAC) */ /* FOR COST_GROUP_TYPE OF 2, WE JOINED WITH XLE TABLE TO GET LEGAL ENTITY */ /* INFORMATION. */ CG.ROWID ROW_ID, CG.COST_GROUP_ID COST_GROUP_ID, CG.COST_GROUP COST_GROUP, CG.ORGANIZATION_ID ORGANIZATION_ID, DECODE ( NVL ( CG.ORGANIZATION_ID, -1 ) , -1, 1, 2 ) MULTI_ORG_FLAG, CG.DESCRIPTION DESCRIPTION, CG.DISABLE_DATE DISABLE_DATE, CG.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, CG.ATTRIBUTE1, CG.ATTRIBUTE2, CG.ATTRIBUTE3, CG.ATTRIBUTE4, CG.ATTRIBUTE5, CG.ATTRIBUTE6, CG.ATTRIBUTE7, CG.ATTRIBUTE8, CG.ATTRIBUTE9, CG.ATTRIBUTE10, CG.ATTRIBUTE11, CG.ATTRIBUTE12, CG.ATTRIBUTE13, CG.ATTRIBUTE14, CG.ATTRIBUTE15, CG.LAST_UPDATE_DATE, CG.LAST_UPDATED_BY, CG.CREATION_DATE, CG.CREATED_BY, CG.LAST_UPDATE_LOGIN, CG.REQUEST_ID, CG.PROGRAM_APPLICATION_ID, CG.PROGRAM_ID, CG.PROGRAM_UPDATE_DATE, CG.LEGAL_ENTITY, NVL(CG.COST_GROUP_TYPE,1), DECODE ( CG.COST_GROUP_TYPE,2,XEP.NAME,NULL ) LEGAL_ENTITY_NAME, DECODE ( CG.COST_GROUP_TYPE, 2,HAOUT1.NAME, NULL ) ORGANIZATION_NAME FROM CST_COST_GROUPS CG, XLE_ENTITY_PROFILES XEP, HR_ALL_ORGANIZATION_UNITS_TL HAOUT1 WHERE CG.LEGAL_ENTITY = XEP.LEGAL_ENTITY_ID(+) AND CG.ORGANIZATION_ID = HAOUT1.ORGANIZATION_ID ( + ) AND NVL(HAOUT1.LANGUAGE, userenv('LANG')) = userenv('LANG')

View Text - HTML Formatted

SELECT /* THIS VIEW IS MODIFIED FOR PAC IN 11.5 */ /* THE VIEW IS THE UNION OF TWO COST GROUP TYPES IN CST_COST_GROUPS TABLE: */ /* O COST_GROUP_TYPE OF 1 = PROJECT COST GROUP */ /* O COST_GROUP_TYPE OF 2 = ORG COST GROUP (USED FOR PAC) */ /* FOR COST_GROUP_TYPE OF 2
, WE JOINED WITH XLE TABLE TO GET LEGAL ENTITY */ /* INFORMATION. */ CG.ROWID ROW_ID
, CG.COST_GROUP_ID COST_GROUP_ID
, CG.COST_GROUP COST_GROUP
, CG.ORGANIZATION_ID ORGANIZATION_ID
, DECODE ( NVL ( CG.ORGANIZATION_ID
, -1 )
, -1
, 1
, 2 ) MULTI_ORG_FLAG
, CG.DESCRIPTION DESCRIPTION
, CG.DISABLE_DATE DISABLE_DATE
, CG.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CG.ATTRIBUTE1
, CG.ATTRIBUTE2
, CG.ATTRIBUTE3
, CG.ATTRIBUTE4
, CG.ATTRIBUTE5
, CG.ATTRIBUTE6
, CG.ATTRIBUTE7
, CG.ATTRIBUTE8
, CG.ATTRIBUTE9
, CG.ATTRIBUTE10
, CG.ATTRIBUTE11
, CG.ATTRIBUTE12
, CG.ATTRIBUTE13
, CG.ATTRIBUTE14
, CG.ATTRIBUTE15
, CG.LAST_UPDATE_DATE
, CG.LAST_UPDATED_BY
, CG.CREATION_DATE
, CG.CREATED_BY
, CG.LAST_UPDATE_LOGIN
, CG.REQUEST_ID
, CG.PROGRAM_APPLICATION_ID
, CG.PROGRAM_ID
, CG.PROGRAM_UPDATE_DATE
, CG.LEGAL_ENTITY
, NVL(CG.COST_GROUP_TYPE
, 1)
, DECODE ( CG.COST_GROUP_TYPE
, 2
, XEP.NAME
, NULL ) LEGAL_ENTITY_NAME
, DECODE ( CG.COST_GROUP_TYPE
, 2
, HAOUT1.NAME
, NULL ) ORGANIZATION_NAME
FROM CST_COST_GROUPS CG
, XLE_ENTITY_PROFILES XEP
, HR_ALL_ORGANIZATION_UNITS_TL HAOUT1
WHERE CG.LEGAL_ENTITY = XEP.LEGAL_ENTITY_ID(+)
AND CG.ORGANIZATION_ID = HAOUT1.ORGANIZATION_ID ( + )
AND NVL(HAOUT1.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')