View: CST_COST_GROUPS_V

Product:	BOM - Bills of Material
Description:	This view is based on CST_COST_GROUPS table
Implementation/DBA Data:	APPS.CST_COST_GROUPS_V

View Text

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')

Columns