Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT REL.ROWID
, REL.PARTY_RELATIONSHIP_ID
, REL.SUBJECT_ID
, SUB.PARTY_TYPE
, LKUP3.MEANING
, SUB.PARTY_NAME
, REL.OBJECT_ID
, REL.PARTY_ID
, REL.PARTY_RELATIONSHIP_TYPE
, LKUP1.MEANING
, REL.DIRECTIONAL_FLAG
, REL.START_DATE
, REL.END_DATE
, REL.LAST_UPDATE_DATE
, REL.LAST_UPDATED_BY
, REL.LAST_UPDATE_LOGIN
, REL.CREATED_BY
, REL.CREATION_DATE
, REL.STATUS
, LKUP2.MEANING
, 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
FROM HZ_PARTY_RELATIONSHIPS REL
, HZ_PARTIES SUB
, AR_LOOKUPS LKUP1
, AR_LOOKUPS LKUP2
, AR_LOOKUPS LKUP3
WHERE REL.SUBJECT_ID = SUB.PARTY_ID AND REL.STATUS = LKUP2.LOOKUP_CODE(+)
AND LKUP2.LOOKUP_TYPE(+) = 'REGISTRY_STATUS' AND REL.PARTY_RELATIONSHIP_TYPE = LKUP1.LOOKUP_CODE(+) AND LKUP1.LOOKUP_TYPE(+) = 'PARTY_RELATIONS_TYPE' AND SUB.PARTY_TYPE = LKUP3.LOOKUP_CODE(+) AND LKUP3.LOOKUP_TYPE(+) = 'PARTY_TYPE'