View: HZ_RELATIONSHIPS_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.HZ_RELATIONSHIPS_V

View Text

SELECT REL.ROWID ROW_ID
, REL.RELATIONSHIP_ID RELATIONSHIP_ID
, REL.SUBJECT_ID SUBJECT_ID
, REL.SUBJECT_TYPE SUBJECT_TYPE
, REL.SUBJECT_TABLE_NAME SUBJECT_TABLE_NAME
, REL.OBJECT_ID OBJECT_ID
, REL.OBJECT_TYPE OBJECT_TYPE
, REL.OBJECT_TABLE_NAME OBJECT_TABLE_NAME
, REL.PARTY_ID PARTY_ID
, LOOKUP.MEANING RELATIONSHIP_MEANING
, REL.RELATIONSHIP_CODE RELATIONSHIP_CODE
, REL.DIRECTIONAL_FLAG DIRECTIONAL_FLAG
, REL.COMMENTS COMMENTS
, REL.START_DATE START_DATE
, REL.END_DATE END_DATE
, REL.STATUS STATUS
, REL.CREATED_BY CREATED_BY
, REL.CREATION_DATE CREATION_DATE
, REL.LAST_UPDATED_BY LAST_UPDATED_BY
, REL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, REL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REL.WH_UPDATE_DATE WH_UPDATE_DATE
, REL.REQUEST_ID REQUEST_ID
, REL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REL.PROGRAM_ID PROGRAM_ID
, REL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, REL.ATTRIBUTE1 ATTRIBUTE1
, REL.ATTRIBUTE2 ATTRIBUTE2
, REL.ATTRIBUTE3 ATTRIBUTE3
, REL.ATTRIBUTE4 ATTRIBUTE4
, REL.ATTRIBUTE5 ATTRIBUTE5
, REL.ATTRIBUTE6 ATTRIBUTE6
, REL.ATTRIBUTE7 ATTRIBUTE7
, REL.ATTRIBUTE8 ATTRIBUTE8
, REL.ATTRIBUTE9 ATTRIBUTE9
, REL.ATTRIBUTE10 ATTRIBUTE10
, REL.ATTRIBUTE11 ATTRIBUTE11
, REL.ATTRIBUTE12 ATTRIBUTE12
, REL.ATTRIBUTE13 ATTRIBUTE13
, REL.ATTRIBUTE14 ATTRIBUTE14
, REL.ATTRIBUTE15 ATTRIBUTE15
, REL.ATTRIBUTE16 ATTRIBUTE16
, REL.ATTRIBUTE17 ATTRIBUTE17
, REL.ATTRIBUTE18 ATTRIBUTE18
, REL.ATTRIBUTE19 ATTRIBUTE19
, REL.ATTRIBUTE20 ATTRIBUTE20
, REL.CONTENT_SOURCE_TYPE CONTENT_SOURCE_TYPE
, REL.RELATIONSHIP_TYPE RELATIONSHIP_TYPE
, REL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, REL.CREATED_BY_MODULE CREATED_BY_MODULE
, REL.APPLICATION_ID APPLICATION_ID
, PARTY.PARTY_NAME PARTY_NAME
, PARTY.PARTY_NUMBER PARTY_NUMBER
, PARTY.PARTY_TYPE PARTY_TYPE
, LOT.MEANING
FROM HZ_RELATIONSHIPS REL
, HZ_PARTIES PARTY
, AR_LOOKUPS LOOKUP
, AR_LOOKUPS LOT
WHERE SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_ID = PARTY.PARTY_ID
AND LOOKUP.LOOKUP_TYPE = 'PARTY_RELATIONS_TYPE'
AND LOOKUP.LOOKUP_CODE = REL.RELATIONSHIP_CODE
AND LOT.LOOKUP_TYPE = 'PARTY_RELATIONS_TYPE'
AND LOT.LOOKUP_CODE = REL.RELATIONSHIP_TYPE
AND EXISTS ( SELECT 'Y'
FROM HZ_CODE_ASSIGNMENTS CODE
, HZ_RELATIONSHIP_TYPES RELTYPE
WHERE RELTYPE.RELATIONSHIP_TYPE = REL.RELATIONSHIP_TYPE
AND CODE.OWNER_TABLE_ID = RELTYPE.RELATIONSHIP_TYPE_ID
AND CODE.CLASS_CATEGORY = 'RELATIONSHIP_TYPE_GROUP'
AND CODE.CLASS_CODE = 'PARTY_REL_GRP_CUST_INFO'
AND CODE.OWNER_TABLE_NAME = 'HZ_RELATIONSHIP_TYPES')

Columns