[Home] [Help]
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
Name |
ELEMENT_GROUP_ID |
ELEMENT_TYPE_ID |
ELEMENT_TYPE_NAME |
ELEMENT_GROUP_NAME |