Product: | PSP - Labor Distribution |
---|---|
Description: | Shows schedule hierarchies |
Implementation/DBA Data: | APPS.PSP_SCHEDULE_HIERARCHY_V |
SELECT SH.ROWID
, SH.SCHEDULE_HIERARCHY_ID
, SH.ASSIGNMENT_ID
, SH.SCHEDULING_TYPES_CODE
, SH.ELEMENT_GROUP_ID
, EG.ELEMENT_GROUP_NAME
, SH.ELEMENT_TYPE_ID
, ET.ELEMENT_NAME
, SH.LAST_UPDATE_DATE
, SH.LAST_UPDATED_BY
, SH.LAST_UPDATE_LOGIN
, SH.CREATED_BY
, SH.CREATION_DATE
, SH.BUSINESS_GROUP_ID
, SH.SET_OF_BOOKS_ID
FROM PSP_SCHEDULE_HIERARCHY SH
, PSP_ELEMENT_GROUPS EG
, PAY_ELEMENT_TYPES_F ET
WHERE SH.ELEMENT_GROUP_ID = EG.ELEMENT_GROUP_ID(+)
AND SH.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID(+)