View: PQH_RULE_SETS_VL

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

View Text

SELECT RST.ROWID ROW_ID
, RST.RULE_SET_ID RULE_SET_ID
, RST.REFERENCED_RULE_SET_ID REFERENCED_RULE_SET_ID
, RST.ORGANIZATION_STRUCTURE_ID ORGANIZATION_STRUCTURE_ID
, RST.ORGANIZATION_ID ORGANIZATION_ID
, RST.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, RST.RULE_LEVEL_CD RULE_LEVEL_CD
, 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
, RTL.RULE_SET_NAME RULE_SET_NAME
, RST.SHORT_NAME SHORT_NAME
, RTL.DESCRIPTION DESCRIPTION
, 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_TL RTL
, PQH_RULE_SETS RST
WHERE RST.RULE_SET_ID = RTL.RULE_SET_ID
AND RTL.LANGUAGE = USERENV('LANG')

Columns