VIEW: APPS.CSM_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 FROM CSM_HZ_RELATIONSHIPS_ACC A , HZ_RELATIONSHIPS B WHERE A.RELATIONSHIP_ID = B.RELATIONSHIP_ID AND A.DIRECTIONAL_FLAG = B.DIRECTIONAL_FLAG AND A.USER_ID = ASG_BASE.GET_USER_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
FROM CSM_HZ_RELATIONSHIPS_ACC A
, HZ_RELATIONSHIPS B
WHERE A.RELATIONSHIP_ID = B.RELATIONSHIP_ID
AND A.DIRECTIONAL_FLAG = B.DIRECTIONAL_FLAG
AND A.USER_ID = ASG_BASE.GET_USER_ID