VIEW: APPS.PQH_DE_WHITE_COLLAR_V

Source

View Text - Preformatted

SELECT Node_type, Hierarchy_Node_Id, Parent_Hierarchy_Node_Id, Entity_Id, (Select Hierarchy_Version_id from Per_Gen_Hierarchy_Versions where Hierarchy_version_id = a.Hierarchy_Version_Id) Hierarchy_Version_id, (Select Date_From from Per_Gen_Hierarchy_Versions where Hierarchy_version_id = a.Hierarchy_Version_Id) Date_From , (Select Date_To from Per_Gen_Hierarchy_Versions where Hierarchy_version_id = a.Hierarchy_Version_Id) date_to from Per_gen_Hierarchy_Nodes a WHERE HIerarchy_Version_Id in (Select Hierarchy_Version_Id from Per_gen_Hierarchy a, Per_Gen_Hierarchy_Versions b where type = 'REMUNERATION_REGULATION' and b.Hierarchy_Id = a.Hierarchy_Id) Start with Entity_Id = 'WC' and parent_Hierarchy_Node_id is NULL Connect By Parent_hierarchy_Node_id = Prior Hierarchy_Node_Id

View Text - HTML Formatted

SELECT NODE_TYPE
, HIERARCHY_NODE_ID
, PARENT_HIERARCHY_NODE_ID
, ENTITY_ID
, (SELECT HIERARCHY_VERSION_ID
FROM PER_GEN_HIERARCHY_VERSIONS
WHERE HIERARCHY_VERSION_ID = A.HIERARCHY_VERSION_ID) HIERARCHY_VERSION_ID
, (SELECT DATE_FROM
FROM PER_GEN_HIERARCHY_VERSIONS
WHERE HIERARCHY_VERSION_ID = A.HIERARCHY_VERSION_ID) DATE_FROM
, (SELECT DATE_TO
FROM PER_GEN_HIERARCHY_VERSIONS
WHERE HIERARCHY_VERSION_ID = A.HIERARCHY_VERSION_ID) DATE_TO
FROM PER_GEN_HIERARCHY_NODES A
WHERE HIERARCHY_VERSION_ID IN (SELECT HIERARCHY_VERSION_ID
FROM PER_GEN_HIERARCHY A
, PER_GEN_HIERARCHY_VERSIONS B
WHERE TYPE = 'REMUNERATION_REGULATION'
AND B.HIERARCHY_ID = A.HIERARCHY_ID) START WITH ENTITY_ID = 'WC'
AND PARENT_HIERARCHY_NODE_ID IS NULL CONNECT BY PARENT_HIERARCHY_NODE_ID = PRIOR HIERARCHY_NODE_ID