View: PQH_RULE_SETS_V

Product:	PQH - Public Sector HR
Description:	Rules Set View
Implementation/DBA Data:	APPS.PQH_RULE_SETS_V

View Text

SELECT RST.ROWID ROW_ID
, RST.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BG.NAME BUSINESS_GROUP
, RST.RULE_SET_ID RULE_SET_ID
, RST.REFERENCED_RULE_SET_ID REFERENCED_RULE_SET_ID
, RST.ORGANIZATION_STRUCTURE_ID ORGANIZATION_STRUCTURE_ID
, OS.NAME ORGANIZATION_STRUCTURE_NAME
, RST.ORGANIZATION_ID ORGANIZATION_ID
, ORG.NAME ORGANIZATION_NAME
, RST.RULE_LEVEL_CD RULE_LEVEL_CD
, F.MEANING RULE_LEVEL
, RST.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RST.CREATION_DATE CREATION_DATE
, RST.CREATED_BY CREATED_BY
, RST.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RST.LAST_UPDATED_BY LAST_UPDATED_BY
, RST.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RST.RULE_SET_NAME RULE_SET_NAME
, RST.SHORT_NAME SHORT_NAME
, RST.DESCRIPTION DESCRIPTION
, RST1.RULE_SET_NAME REFERENCED_RULE_SET_NAME
, RST.RULE_APPLICABILITY RULE_APPLICABILITY
, RST.STARTING_ORGANIZATION_ID STARTING_ORGANIZATION_ID
, RST.RULE_CATEGORY RULE_CATEGORY
, RST.SEEDED_RULE_FLAG SEEDED_RULE_FLAG
FROM PQH_RULE_SETS_VL RST
, PQH_RULE_SETS_VL RST1
, PER_BUSINESS_GROUPS BG
, PER_ORGANIZATION_STRUCTURES OS
, HR_ALL_ORGANIZATION_UNITS ORG
, HR_LOOKUPS F
WHERE RST.REFERENCED_RULE_SET_ID = RST1.RULE_SET_ID(+)
AND RST.BUSINESS_GROUP_ID = BG.BUSINESS_GROUP_ID (+)
AND RST.ORGANIZATION_STRUCTURE_ID = OS.ORGANIZATION_STRUCTURE_ID(+)
AND RST.STARTING_ORGANIZATION_ID = ORG.ORGANIZATION_ID(+)
AND RST.RULE_LEVEL_CD = F.LOOKUP_CODE(+)
AND F.LOOKUP_TYPE(+) = 'PQH_RULE_LEVEL'

Columns