VIEW: APPS.CS_SR_LINK_VALID_OBJ_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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