VIEW: APPS.PQH_RULE_SETS_V

Source

View Text - Preformatted

SELECT RST.ROW_ID 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'

View Text - HTML Formatted

SELECT RST.ROW_ID 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'