VIEW: APPS.JTF_PARTY_RELATIONSHIPS_V

Source

View Text - Preformatted

SELECT REL.ROWID , REL.OBJECT_ID , REL.SUBJECT_ID , REL.LAST_UPDATE_DATE , REL.LAST_UPDATED_BY , REL.CREATION_DATE , REL.CREATED_BY , REL.LAST_UPDATE_LOGIN , REL.RELATIONSHIP_CODE, LOOK1.MEANING , CUST1.PARTY_NAME , CUST1.PARTY_NUMBER , CUST2.PARTY_NAME , CUST2.PARTY_NUMBER , REL.START_DATE , REL.END_DATE , REL.COMMENTS , 'N', 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 FROM HZ_RELATIONSHIPS REL, FND_LOOKUPS LOOK1 , HZ_PARTIES CUST1 , HZ_PARTIES CUST2 WHERE REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES' AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES' AND REL.DIRECTIONAL_FLAG = 'F' AND REL.OBJECT_ID = CUST2.PARTY_ID AND REL.SUBJECT_ID = CUST1.PARTY_ID AND REL.RELATIONSHIP_CODE = LOOK1.LOOKUP_CODE(+) AND LOOK1.LOOKUP_TYPE(+) = 'RELATIONSHIP_TYPE'

View Text - HTML Formatted

SELECT REL.ROWID
, REL.OBJECT_ID
, REL.SUBJECT_ID
, REL.LAST_UPDATE_DATE
, REL.LAST_UPDATED_BY
, REL.CREATION_DATE
, REL.CREATED_BY
, REL.LAST_UPDATE_LOGIN
, REL.RELATIONSHIP_CODE
, LOOK1.MEANING
, CUST1.PARTY_NAME
, CUST1.PARTY_NUMBER
, CUST2.PARTY_NAME
, CUST2.PARTY_NUMBER
, REL.START_DATE
, REL.END_DATE
, REL.COMMENTS
, 'N'
, 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
FROM HZ_RELATIONSHIPS REL
, FND_LOOKUPS LOOK1
, HZ_PARTIES CUST1
, HZ_PARTIES CUST2
WHERE REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.DIRECTIONAL_FLAG = 'F'
AND REL.OBJECT_ID = CUST2.PARTY_ID
AND REL.SUBJECT_ID = CUST1.PARTY_ID
AND REL.RELATIONSHIP_CODE = LOOK1.LOOKUP_CODE(+)
AND LOOK1.LOOKUP_TYPE(+) = 'RELATIONSHIP_TYPE'