VIEW: APPS.CSL_HZ_RELATIONSHIPS_V

Source

View Text - Preformatted

SELECT A.ACCESS_ID , B.RELATIONSHIP_ID , B.SUBJECT_ID , B.OBJECT_ID , B.PARTY_ID , B.RELATIONSHIP_CODE , B.DIRECTIONAL_FLAG , B.COMMENTS , B.START_DATE , B.END_DATE , B.STATUS , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.LAST_UPDATE_LOGIN , B.WH_UPDATE_DATE , B.REQUEST_ID , B.PROGRAM_APPLICATION_ID , B.PROGRAM_ID , B.PROGRAM_UPDATE_DATE FROM CSL_HZ_RELATIONSHIPS_ACC A , HZ_RELATIONSHIPS B WHERE A.RELATIONSHIP_ID = B.RELATIONSHIP_ID AND A.DIRECTIONAL_FLAG = B.DIRECTIONAL_FLAG AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID

View Text - HTML Formatted

SELECT A.ACCESS_ID
, B.RELATIONSHIP_ID
, B.SUBJECT_ID
, B.OBJECT_ID
, B.PARTY_ID
, B.RELATIONSHIP_CODE
, B.DIRECTIONAL_FLAG
, B.COMMENTS
, B.START_DATE
, B.END_DATE
, B.STATUS
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.WH_UPDATE_DATE
, B.REQUEST_ID
, B.PROGRAM_APPLICATION_ID
, B.PROGRAM_ID
, B.PROGRAM_UPDATE_DATE
FROM CSL_HZ_RELATIONSHIPS_ACC A
, HZ_RELATIONSHIPS B
WHERE A.RELATIONSHIP_ID = B.RELATIONSHIP_ID
AND A.DIRECTIONAL_FLAG = B.DIRECTIONAL_FLAG
AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID