View: HZ_DSS_SECURED_REL_TYPES_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.HZ_DSS_SECURED_REL_TYPES_V

View Text

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

Columns