VIEW: APPS.HZ_DSS_SECURED_REL_TYPES_V

Source

View Text - Preformatted

SELECT HDC.SECURED_ITEM_ID, HDC.STATUS, HDC.DSS_GROUP_CODE, TO_NUMBER(HDC.OWNER_TABLE_ID1) RELATIONSHIP_TYPE_ID, HRT.RELATIONSHIP_TYPE, HRT.FORWARD_REL_CODE, HRT.BACKWARD_REL_CODE, HRT.ROLE, ARL.MEANING ROLE_MEANING, HDC.OBJECT_VERSION_NUMBER, HDC.LAST_UPDATE_DATE, HDC.LAST_UPDATED_BY, HDC.CREATION_DATE, HDC.CREATED_BY, HDC.LAST_UPDATE_LOGIN FROM HZ_DSS_CRITERIA HDC, HZ_RELATIONSHIP_TYPES HRT, AR_LOOKUPS ARL WHERE HDC.OWNER_TABLE_NAME = 'HZ_RELATIONSHIP_TYPES' AND TO_NUMBER(HDC.OWNER_TABLE_ID1) = HRT.RELATIONSHIP_TYPE_ID AND ARL.LOOKUP_TYPE (+) = 'HZ_RELATIONSHIP_ROLE' AND ARL.LOOKUP_CODE (+) = HRT.ROLE

View Text - HTML Formatted

SELECT HDC.SECURED_ITEM_ID
, HDC.STATUS
, HDC.DSS_GROUP_CODE
, TO_NUMBER(HDC.OWNER_TABLE_ID1) RELATIONSHIP_TYPE_ID
, HRT.RELATIONSHIP_TYPE
, HRT.FORWARD_REL_CODE
, HRT.BACKWARD_REL_CODE
, HRT.ROLE
, ARL.MEANING ROLE_MEANING
, HDC.OBJECT_VERSION_NUMBER
, HDC.LAST_UPDATE_DATE
, HDC.LAST_UPDATED_BY
, HDC.CREATION_DATE
, HDC.CREATED_BY
, HDC.LAST_UPDATE_LOGIN
FROM HZ_DSS_CRITERIA HDC
, HZ_RELATIONSHIP_TYPES HRT
, AR_LOOKUPS ARL
WHERE HDC.OWNER_TABLE_NAME = 'HZ_RELATIONSHIP_TYPES'
AND TO_NUMBER(HDC.OWNER_TABLE_ID1) = HRT.RELATIONSHIP_TYPE_ID
AND ARL.LOOKUP_TYPE (+) = 'HZ_RELATIONSHIP_ROLE'
AND ARL.LOOKUP_CODE (+) = HRT.ROLE