View: PSP_ELEMENT_GROUP_V

Product:	PSP - Labor Distribution
Description:	Shows element groups for Schedule Summary window
Implementation/DBA Data:	APPS.PSP_ELEMENT_GROUP_V

View Text

SELECT GE.ELEMENT_GROUP_ID
, GE.ELEMENT_TYPE_ID
, HR.ELEMENT_NAME
, EG.ELEMENT_GROUP_NAME
FROM PSP_GROUP_ELEMENT_LIST GE
, PSP_ELEMENT_GROUPS EG
, PAY_ELEMENT_TYPES_F HR
, PSP_ELEMENT_TYPES ET
WHERE EG.ELEMENT_GROUP_ID = GE.ELEMENT_GROUP_ID
AND ET.ELEMENT_TYPE_ID = GE.ELEMENT_TYPE_ID
AND ET.ELEMENT_TYPE_ID = HR.ELEMENT_TYPE_ID GROUP BY GE.ELEMENT_GROUP_ID
, GE.ELEMENT_TYPE_ID
, HR.ELEMENT_NAME
, EG.ELEMENT_GROUP_NAME UNION SELECT DECODE(GE.ELEMENT_GROUP_ID
, GE.ELEMENT_GROUP_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL))
, ET.ELEMENT_TYPE_ID
, ET.ELEMENT_NAME
, DECODE(ET.ATTRIBUTE_CATEGORY
, ET.ATTRIBUTE_CATEGORY
, NULL
, NULL)
FROM PSP_ELEMENT_TYPES_V ET
, PSP_GROUP_ELEMENT_LIST GE
WHERE GE.ELEMENT_TYPE_ID (+) = ET.ELEMENT_TYPE_ID

Columns