View: CS_SR_LINK_VALID_OBJ_V

Product:	CS - Service
Description:
Implementation/DBA Data:	APPS.CS_SR_LINK_VALID_OBJ_V

View Text

SELECT A.LINK_VALID_OBJ_ID LINK_VALID_OBJ_ID
, B.LINK_TYPE_ID LINK_TYPE_ID
, B.NAME NAME
, B.DESCRIPTION DESCRIPTION
, A.SUBJECT_TYPE SUBJECT_TYPE
, C.NAME SUBJECT_NAME
, C.DESCRIPTION SUBJECT_DESCRIPTION
, A.OBJECT_TYPE OBJECT_TYPE
, D.NAME OBJECT_NAME
, D.DESCRIPTION OBJECT_DESCRIPTION
, A.START_DATE_ACTIVE START_DATE_ACTIVE
, A.END_DATE_ACTIVE END_DATE_ACTIVE
, A.LAST_UPDATE_DATE LAST_UPDATE_DATE
, A.LAST_UPDATED_BY LAST_UPDATED_BY
, A.CREATION_DATE CREATION_DATE
, A.CREATED_BY CREATED_BY
, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, A.APPLICATION_ID APPLICATION_ID
, A.SEEDED_FLAG SEEDED_FLAG
, A.SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM CS_SR_LINK_VALID_OBJ A
, CS_SR_LINK_TYPES_VL B
, JTF_OBJECTS_VL C
, JTF_OBJECTS_VL D
WHERE A.LINK_TYPE_ID = B.LINK_TYPE_ID AND A.SUBJECT_TYPE = C.OBJECT_CODE AND A.OBJECT_TYPE = D.OBJECT_CODE

Columns