VIEW: APPS.AST_SUBJECT_RELATIONSHIP_V

Source

View Text - Preformatted

SELECT REL.ROWID , REL.RELATIONSHIP_ID , REL.SUBJECT_ID , REL.SUBJECT_TYPE , REL.OBJECT_ID , REL.OBJECT_TYPE , LKUP1.MEANING , OBJ.PARTY_NAME , REL.PARTY_ID , RELPARTY.PARTY_NUMBER , RELPARTY.ORIG_SYSTEM_REFERENCE , REL.RELATIONSHIP_TYPE , REL.RELATIONSHIP_CODE , LKUP2.DESCRIPTION , REL.DIRECTIONAL_FLAG , REL.START_DATE , DECODE(TO_CHAR(REL.END_DATE,'DD-MM-RRRR'),'31-12-4712',TO_DATE(NULL), REL.END_DATE) , REL.STATUS , RELPARTY.STATUS , REL.CREATED_BY , REL.CREATION_DATE , REL.LAST_UPDATED_BY , REL.LAST_UPDATE_DATE , REL.LAST_UPDATE_LOGIN , 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 , REL.OBJECT_VERSION_NUMBER , REL.CREATED_BY_MODULE , REL.APPLICATION_ID , RELPARTY.OBJECT_VERSION_NUMBER , RELPARTY.CREATED_BY_MODULE , RELPARTY.APPLICATION_ID FROM HZ_RELATIONSHIPS REL , HZ_PARTIES OBJ , AR_LOOKUPS LKUP1 , AR_LOOKUPS LKUP2 , HZ_PARTIES RELPARTY , HZ_RELATIONSHIP_TYPES HZ WHERE REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES' AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES' AND REL.OBJECT_ID = OBJ.PARTY_ID AND LKUP1.LOOKUP_TYPE(+) = 'PARTY_TYPE' AND REL.OBJECT_TYPE = LKUP1.LOOKUP_CODE(+) AND LKUP2.LOOKUP_TYPE(+) = 'HZ_RELATIONSHIP_ROLE' AND HZ.ROLE = LKUP2.LOOKUP_CODE(+) AND REL.PARTY_ID = RELPARTY.PARTY_ID(+) AND REL.OBJECT_TYPE=HZ.OBJECT_TYPE AND REL.SUBJECT_TYPE=HZ.SUBJECT_TYPE AND REL.RELATIONSHIP_TYPE=HZ.RELATIONSHIP_TYPE AND REL.RELATIONSHIP_CODE=HZ.FORWARD_REL_CODE

View Text - HTML Formatted

SELECT REL.ROWID
, REL.RELATIONSHIP_ID
, REL.SUBJECT_ID
, REL.SUBJECT_TYPE
, REL.OBJECT_ID
, REL.OBJECT_TYPE
, LKUP1.MEANING
, OBJ.PARTY_NAME
, REL.PARTY_ID
, RELPARTY.PARTY_NUMBER
, RELPARTY.ORIG_SYSTEM_REFERENCE
, REL.RELATIONSHIP_TYPE
, REL.RELATIONSHIP_CODE
, LKUP2.DESCRIPTION
, REL.DIRECTIONAL_FLAG
, REL.START_DATE
, DECODE(TO_CHAR(REL.END_DATE
, 'DD-MM-RRRR')
, '31-12-4712'
, TO_DATE(NULL)
, REL.END_DATE)
, REL.STATUS
, RELPARTY.STATUS
, REL.CREATED_BY
, REL.CREATION_DATE
, REL.LAST_UPDATED_BY
, REL.LAST_UPDATE_DATE
, REL.LAST_UPDATE_LOGIN
, 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
, REL.OBJECT_VERSION_NUMBER
, REL.CREATED_BY_MODULE
, REL.APPLICATION_ID
, RELPARTY.OBJECT_VERSION_NUMBER
, RELPARTY.CREATED_BY_MODULE
, RELPARTY.APPLICATION_ID
FROM HZ_RELATIONSHIPS REL
, HZ_PARTIES OBJ
, AR_LOOKUPS LKUP1
, AR_LOOKUPS LKUP2
, HZ_PARTIES RELPARTY
, HZ_RELATIONSHIP_TYPES HZ
WHERE REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_ID = OBJ.PARTY_ID
AND LKUP1.LOOKUP_TYPE(+) = 'PARTY_TYPE'
AND REL.OBJECT_TYPE = LKUP1.LOOKUP_CODE(+)
AND LKUP2.LOOKUP_TYPE(+) = 'HZ_RELATIONSHIP_ROLE'
AND HZ.ROLE = LKUP2.LOOKUP_CODE(+)
AND REL.PARTY_ID = RELPARTY.PARTY_ID(+)
AND REL.OBJECT_TYPE=HZ.OBJECT_TYPE
AND REL.SUBJECT_TYPE=HZ.SUBJECT_TYPE
AND REL.RELATIONSHIP_TYPE=HZ.RELATIONSHIP_TYPE
AND REL.RELATIONSHIP_CODE=HZ.FORWARD_REL_CODE