VIEW: APPS.PQH_RULE_SETS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')