VIEW: APPS.RRS_SECURED_OBJECTS_V

Source

View Text - Preformatted

SELECT lookup_code pk_id,Meaning pk_name, description pk_desc, 'SB' pk_type from rrs_lookups_v where lookup_type = 'RRS_BRAND_NAME' UNION ALL select lookup_code pk_id,Meaning pk_name, description pk_desc, 'SS' pk_type from rrs_lookups_v where lookup_type = 'RRS_SITE_STATUS' UNION ALL select lookup_code pk_id,Meaning pk_name, description pk_desc, 'ST' pk_type from rrs_lookups_v where lookup_type = 'RRS_SITE_TYPE' UNION ALL select lookup_code pk_id,Meaning pk_name, description pk_desc , 'SP' pk_type from AR_LOOKUPS where LOOKUP_TYPE='PARTY_SITE_USE_CODE' AND ENABLED_FLAG='Y' UNION ALL select lookup_code pk_id,Meaning pk_name, description pk_desc , 'HP' pk_type from RRS_LOOKUPS_V where LOOKUP_TYPE='RRS_HIERARCHY_PURPOSE'

View Text - HTML Formatted

SELECT LOOKUP_CODE PK_ID
, MEANING PK_NAME
, DESCRIPTION PK_DESC
, 'SB' PK_TYPE
FROM RRS_LOOKUPS_V
WHERE LOOKUP_TYPE = 'RRS_BRAND_NAME' UNION ALL SELECT LOOKUP_CODE PK_ID
, MEANING PK_NAME
, DESCRIPTION PK_DESC
, 'SS' PK_TYPE
FROM RRS_LOOKUPS_V
WHERE LOOKUP_TYPE = 'RRS_SITE_STATUS' UNION ALL SELECT LOOKUP_CODE PK_ID
, MEANING PK_NAME
, DESCRIPTION PK_DESC
, 'ST' PK_TYPE
FROM RRS_LOOKUPS_V
WHERE LOOKUP_TYPE = 'RRS_SITE_TYPE' UNION ALL SELECT LOOKUP_CODE PK_ID
, MEANING PK_NAME
, DESCRIPTION PK_DESC
, 'SP' PK_TYPE
FROM AR_LOOKUPS
WHERE LOOKUP_TYPE='PARTY_SITE_USE_CODE'
AND ENABLED_FLAG='Y' UNION ALL SELECT LOOKUP_CODE PK_ID
, MEANING PK_NAME
, DESCRIPTION PK_DESC
, 'HP' PK_TYPE
FROM RRS_LOOKUPS_V
WHERE LOOKUP_TYPE='RRS_HIERARCHY_PURPOSE'