VIEW: APPS.CSC_HZ_PARTY_RELATIONSHIPS_V

Source

View Text - Preformatted

SELECT PARTY.ROWID , PARTY.PARTY_ID, PARTY_REL.RELATIONSHIP_ID, party.party_number, SUB_PARTY.PARTY_ID, OBJ_PARTY.PARTY_ID, OBJ_PARTY.PARTY_TYPE, SUB_PARTY.PARTY_TYPE, PARTY_REL.RELATIONSHIP_TYPE, OBJ_PARTY.PARTY_NAME, SUB_PARTY.PARTY_NAME, ORG_CONT.JOB_TITLE_CODE, OBJ_PARTY.last_update_date, PARTY_REL.START_DATE, party_rel.end_date, party_rel.status, party_rel.comments, party_rel.directional_flag, party_rel.relationship_code, l.meaning, PARTY_REL.object_version_number, PARTY.object_version_number PARTY_OBJECT_VERSION_NUMBER FROM HZ_PARTIES PARTY, HZ_PARTIES SUB_PARTY, HZ_PARTIES OBJ_PARTY, HZ_RELATIONSHIPS PARTY_REL, AR_LOOKUPS l, HZ_ORG_CONTACTS ORG_CONT WHERE PARTY.PARTY_ID(+) = PARTY_REL.PARTY_ID AND (PARTY_REL.SUBJECT_ID = SUB_PARTY.PARTY_ID AND PARTY_REL.OBJECT_ID = OBJ_PARTY.PARTY_ID) AND ORG_CONT.PARTY_RELATIONSHIP_ID = PARTY_REL.RELATIONSHIP_ID AND l.lookup_type = 'PARTY_RELATIONS_TYPE' AND l.lookup_code = party_rel.relationship_code -- AND nvl(PARTY_REL.START_DATE, sysdate-1) < sysdate -- AND nvl(party_rel.end_date, sysdate+1) > sysdate

View Text - HTML Formatted

SELECT PARTY.ROWID
, PARTY.PARTY_ID
, PARTY_REL.RELATIONSHIP_ID
, PARTY.PARTY_NUMBER
, SUB_PARTY.PARTY_ID
, OBJ_PARTY.PARTY_ID
, OBJ_PARTY.PARTY_TYPE
, SUB_PARTY.PARTY_TYPE
, PARTY_REL.RELATIONSHIP_TYPE
, OBJ_PARTY.PARTY_NAME
, SUB_PARTY.PARTY_NAME
, ORG_CONT.JOB_TITLE_CODE
, OBJ_PARTY.LAST_UPDATE_DATE
, PARTY_REL.START_DATE
, PARTY_REL.END_DATE
, PARTY_REL.STATUS
, PARTY_REL.COMMENTS
, PARTY_REL.DIRECTIONAL_FLAG
, PARTY_REL.RELATIONSHIP_CODE
, L.MEANING
, PARTY_REL.OBJECT_VERSION_NUMBER
, PARTY.OBJECT_VERSION_NUMBER PARTY_OBJECT_VERSION_NUMBER
FROM HZ_PARTIES PARTY
, HZ_PARTIES SUB_PARTY
, HZ_PARTIES OBJ_PARTY
, HZ_RELATIONSHIPS PARTY_REL
, AR_LOOKUPS L
, HZ_ORG_CONTACTS ORG_CONT
WHERE PARTY.PARTY_ID(+) = PARTY_REL.PARTY_ID
AND (PARTY_REL.SUBJECT_ID = SUB_PARTY.PARTY_ID
AND PARTY_REL.OBJECT_ID = OBJ_PARTY.PARTY_ID)
AND ORG_CONT.PARTY_RELATIONSHIP_ID = PARTY_REL.RELATIONSHIP_ID
AND L.LOOKUP_TYPE = 'PARTY_RELATIONS_TYPE'
AND L.LOOKUP_CODE = PARTY_REL.RELATIONSHIP_CODE --
AND NVL(PARTY_REL.START_DATE
, SYSDATE-1) < SYSDATE --
AND NVL(PARTY_REL.END_DATE
, SYSDATE+1) > SYSDATE