Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_RELATIONSHIP_V |
SELECT REL.ROWID
, REL.RELATIONSHIP_ID
, REL.SUBJECT_ID
, REL.OBJECT_ID
, REL.PARTY_ID
, PARTY.PARTY_NUMBER
, REL.RELATIONSHIP_CODE
, HZ.ROLE RELATIONSHIP_ROLE_CODE
, LKUP2.MEANING
, LKUP1.MEANING
, REL.DIRECTIONAL_FLAG
, REL.COMMENTS
, REL.START_DATE
, REL.END_DATE
, REL.LAST_UPDATE_DATE
, REL.STATUS
, REL.LAST_UPDATED_BY
, REL.CREATION_DATE
, REL.CREATED_BY
, REL.LAST_UPDATE_LOGIN
, REL.REQUEST_ID
, REL.PROGRAM_APPLICATION_ID
, REL.PROGRAM_ID
, REL.PROGRAM_UPDATE_DATE
, REL.ATTRIBUTE_CATEGORY
, REL.ATTRIBUTE1
, REL.ATTRIBUTE2
, REL.ATTRIBUTE3
, REL.ATTRIBUTE4
, REL.ATTRIBUTE5
, REL.ATTRIBUTE6
, REL.ATTRIBUTE7
, REL.ATTRIBUTE8
, REL.ATTRIBUTE9
, REL.ATTRIBUTE10
, REL.ATTRIBUTE11
, REL.ATTRIBUTE12
, REL.ATTRIBUTE13
, REL.ATTRIBUTE14
, REL.ATTRIBUTE15
, REL.ATTRIBUTE16
, REL.ATTRIBUTE17
, REL.ATTRIBUTE18
, REL.ATTRIBUTE19
, REL.ATTRIBUTE20
FROM HZ_RELATIONSHIPS REL
, HZ_PARTIES PARTY
, HZ_RELATIONSHIP_TYPES HZ
, AR_LOOKUPS LKUP1
, AR_LOOKUPS LKUP2
WHERE HZ.ROLE = LKUP1.LOOKUP_CODE
AND HZ.FORWARD_REL_CODE=LKUP2.LOOKUP_CODE
AND LKUP2.LOOKUP_TYPE = 'PARTY_RELATIONS_TYPE'
AND LKUP1.LOOKUP_TYPE = 'HZ_RELATIONSHIP_ROLE'
AND PARTY.PARTY_ID = REL.PARTY_ID
AND PARTY.PARTY_TYPE = 'PARTY_RELATIONSHIP'
AND HZ.FORWARD_REL_CODE=REL.RELATIONSHIP_CODE
AND HZ.RELATIONSHIP_TYPE=REL.RELATIONSHIP_TYPE
AND HZ.OBJECT_TYPE=REL.OBJECT_TYPE
AND HZ.SUBJECT_TYPE=REL.SUBJECT_TYPE