VIEW: APPS.HZ_PARTY_RELATIONSHIP_V

Source

View Text - Preformatted

SELECT A.RELATIONSHIP_ID , A.PARTY_ID , A.RELATIONSHIP_CODE , L.MEANING , A.COMMENTS , A.START_DATE , A.END_DATE , A.SUBJECT_ID , A.OBJECT_ID , A.ATTRIBUTE_CATEGORY , A.ATTRIBUTE1 , A.ATTRIBUTE2 , A.ATTRIBUTE3 , A.ATTRIBUTE4 , A.ATTRIBUTE5 , A.ATTRIBUTE7 , A.ATTRIBUTE6 , A.ATTRIBUTE8 , A.ATTRIBUTE9 , A.ATTRIBUTE10 , A.LAST_UPDATE_DATE , A.STATUS , A.LAST_UPDATED_BY , A.CREATION_DATE , A.CREATED_BY , A.LAST_UPDATE_LOGIN , A.WH_UPDATE_DATE , A.REQUEST_ID , A.PROGRAM_APPLICATION_ID , A.PROGRAM_ID , A.PROGRAM_UPDATE_DATE , A.ATTRIBUTE11 , A.ATTRIBUTE12 , A.ATTRIBUTE13 , A.ATTRIBUTE14 , A.ATTRIBUTE15 , A.ATTRIBUTE16 , A.ATTRIBUTE17 , A.ATTRIBUTE18 , A.ATTRIBUTE19 , A.ATTRIBUTE20 , A.GLOBAL_ATTRIBUTE_CATEGORY , A.GLOBAL_ATTRIBUTE1 , A.GLOBAL_ATTRIBUTE2 , A.GLOBAL_ATTRIBUTE3 , A.GLOBAL_ATTRIBUTE4 , A.GLOBAL_ATTRIBUTE5 , A.GLOBAL_ATTRIBUTE6 , A.GLOBAL_ATTRIBUTE7 , A.GLOBAL_ATTRIBUTE8 , A.GLOBAL_ATTRIBUTE9 , A.GLOBAL_ATTRIBUTE10 , A.GLOBAL_ATTRIBUTE11 , A.GLOBAL_ATTRIBUTE12 , A.GLOBAL_ATTRIBUTE13 , A.GLOBAL_ATTRIBUTE14 , A.GLOBAL_ATTRIBUTE15 , A.GLOBAL_ATTRIBUTE16 , A.GLOBAL_ATTRIBUTE17 , A.GLOBAL_ATTRIBUTE18 , A.GLOBAL_ATTRIBUTE19 , A.GLOBAL_ATTRIBUTE20 , A.CONTENT_SOURCE_TYPE , A.DIRECTIONAL_FLAG , B.PARTY_ID , B.PARTY_NUMBER , B.PARTY_NAME , B.PARTY_TYPE , B.VALIDATED_FLAG , B.ORIG_SYSTEM_REFERENCE , B.SIC_CODE , B.HQ_BRANCH_IND , B.CUSTOMER_KEY , B.TAX_REFERENCE , B.JGZZ_FISCAL_CODE , B.DUNS_NUMBER , B.TAX_NAME , B.PERSON_PRE_NAME_ADJUNCT , B.PERSON_FIRST_NAME , B.PERSON_MIDDLE_NAME , B.PERSON_LAST_NAME , B.PERSON_NAME_SUFFIX , B.PERSON_TITLE , B.PERSON_ACADEMIC_TITLE , B.PERSON_PREVIOUS_LAST_NAME , B.KNOWN_AS , B.PERSON_IDEN_TYPE , B.PERSON_IDENTIFIER , B.GROUP_TYPE , B.COUNTRY , B.ADDRESS1 , B.ADDRESS2 , B.ADDRESS3 , B.ADDRESS4 , B.CITY , B.POSTAL_CODE , B.STATE , B.PROVINCE , B.STATUS , B.COUNTY , B.SIC_CODE_TYPE , B.TOTAL_NUM_OF_ORDERS , B.TOTAL_ORDERED_AMOUNT , B.LAST_ORDERED_DATE , B.URL , B.EMAIL_ADDRESS , B.DO_NOT_MAIL_FLAG , B.ANALYSIS_FY , B.FISCAL_YEAREND_MONTH , B.EMPLOYEES_TOTAL , B.CURR_FY_POTENTIAL_REVENUE , B.NEXT_FY_POTENTIAL_REVENUE , B.YEAR_ESTABLISHED , B.GSA_INDICATOR_FLAG , B.MISSION_STATEMENT , B.ORGANIZATION_NAME_PHONETIC , B.PERSON_FIRST_NAME_PHONETIC , B.PERSON_LAST_NAME_PHONETIC , B.LANGUAGE_NAME , B.CATEGORY_CODE , B.REFERENCE_USE_FLAG , B.THIRD_PARTY_FLAG , B.COMPETITOR_FLAG , B.SALUTATION , B.KNOWN_AS2 , B.KNOWN_AS4 , B.KNOWN_AS3 , B.KNOWN_AS5 , C.PARTY_ID , C.PARTY_NUMBER , C.PARTY_NAME , C.VALIDATED_FLAG , C.PARTY_TYPE , C.ORIG_SYSTEM_REFERENCE , C.SIC_CODE , C.HQ_BRANCH_IND , C.CUSTOMER_KEY , C.TAX_REFERENCE , C.JGZZ_FISCAL_CODE , C.DUNS_NUMBER , C.TAX_NAME , C.PERSON_PRE_NAME_ADJUNCT , C.PERSON_FIRST_NAME , C.PERSON_MIDDLE_NAME , C.PERSON_LAST_NAME , C.PERSON_NAME_SUFFIX , C.PERSON_TITLE , C.PERSON_ACADEMIC_TITLE , C.PERSON_PREVIOUS_LAST_NAME , C.KNOWN_AS , C.PERSON_IDEN_TYPE , C.PERSON_IDENTIFIER , C.GROUP_TYPE , C.COUNTRY , C.ADDRESS1 , C.ADDRESS2 , C.ADDRESS3 , C.ADDRESS4 , C.CITY , C.POSTAL_CODE , C.STATE , C.PROVINCE , C.STATUS , C.COUNTY , C.SIC_CODE_TYPE , C.TOTAL_NUM_OF_ORDERS , C.TOTAL_ORDERED_AMOUNT , C.LAST_ORDERED_DATE , C.URL , C.EMAIL_ADDRESS , C.DO_NOT_MAIL_FLAG , C.ANALYSIS_FY , C.FISCAL_YEAREND_MONTH , C.EMPLOYEES_TOTAL , C.CURR_FY_POTENTIAL_REVENUE , C.NEXT_FY_POTENTIAL_REVENUE , C.YEAR_ESTABLISHED , C.GSA_INDICATOR_FLAG , C.MISSION_STATEMENT , C.ORGANIZATION_NAME_PHONETIC , C.PERSON_FIRST_NAME_PHONETIC , C.PERSON_LAST_NAME_PHONETIC , C.LANGUAGE_NAME , C.CATEGORY_CODE , C.REFERENCE_USE_FLAG , C.THIRD_PARTY_FLAG , C.COMPETITOR_FLAG , C.SALUTATION , C.KNOWN_AS2 , C.KNOWN_AS3 , C.KNOWN_AS4 , C.KNOWN_AS5 FROM HZ_PARTIES B , HZ_PARTIES C , HZ_RELATIONSHIPS A , AR_LOOKUPS L WHERE (A.SUBJECT_ID = B.PARTY_ID) AND (A.OBJECT_ID = C.PARTY_ID) AND L.LOOKUP_TYPE = 'PARTY_RELATIONS_TYPE' AND L.LOOKUP_CODE(+) = A.RELATIONSHIP_CODE AND A.SUBJECT_TABLE_NAME = 'HZ_PARTIES' AND A.OBJECT_TABLE_NAME = 'HZ_PARTIES' AND A.DIRECTIONAL_FLAG = 'F'

View Text - HTML Formatted

SELECT A.RELATIONSHIP_ID
, A.PARTY_ID
, A.RELATIONSHIP_CODE
, L.MEANING
, A.COMMENTS
, A.START_DATE
, A.END_DATE
, A.SUBJECT_ID
, A.OBJECT_ID
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE7
, A.ATTRIBUTE6
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.LAST_UPDATE_DATE
, A.STATUS
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.WH_UPDATE_DATE
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_UPDATE_DATE
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.ATTRIBUTE16
, A.ATTRIBUTE17
, A.ATTRIBUTE18
, A.ATTRIBUTE19
, A.ATTRIBUTE20
, A.GLOBAL_ATTRIBUTE_CATEGORY
, A.GLOBAL_ATTRIBUTE1
, A.GLOBAL_ATTRIBUTE2
, A.GLOBAL_ATTRIBUTE3
, A.GLOBAL_ATTRIBUTE4
, A.GLOBAL_ATTRIBUTE5
, A.GLOBAL_ATTRIBUTE6
, A.GLOBAL_ATTRIBUTE7
, A.GLOBAL_ATTRIBUTE8
, A.GLOBAL_ATTRIBUTE9
, A.GLOBAL_ATTRIBUTE10
, A.GLOBAL_ATTRIBUTE11
, A.GLOBAL_ATTRIBUTE12
, A.GLOBAL_ATTRIBUTE13
, A.GLOBAL_ATTRIBUTE14
, A.GLOBAL_ATTRIBUTE15
, A.GLOBAL_ATTRIBUTE16
, A.GLOBAL_ATTRIBUTE17
, A.GLOBAL_ATTRIBUTE18
, A.GLOBAL_ATTRIBUTE19
, A.GLOBAL_ATTRIBUTE20
, A.CONTENT_SOURCE_TYPE
, A.DIRECTIONAL_FLAG
, B.PARTY_ID
, B.PARTY_NUMBER
, B.PARTY_NAME
, B.PARTY_TYPE
, B.VALIDATED_FLAG
, B.ORIG_SYSTEM_REFERENCE
, B.SIC_CODE
, B.HQ_BRANCH_IND
, B.CUSTOMER_KEY
, B.TAX_REFERENCE
, B.JGZZ_FISCAL_CODE
, B.DUNS_NUMBER
, B.TAX_NAME
, B.PERSON_PRE_NAME_ADJUNCT
, B.PERSON_FIRST_NAME
, B.PERSON_MIDDLE_NAME
, B.PERSON_LAST_NAME
, B.PERSON_NAME_SUFFIX
, B.PERSON_TITLE
, B.PERSON_ACADEMIC_TITLE
, B.PERSON_PREVIOUS_LAST_NAME
, B.KNOWN_AS
, B.PERSON_IDEN_TYPE
, B.PERSON_IDENTIFIER
, B.GROUP_TYPE
, B.COUNTRY
, B.ADDRESS1
, B.ADDRESS2
, B.ADDRESS3
, B.ADDRESS4
, B.CITY
, B.POSTAL_CODE
, B.STATE
, B.PROVINCE
, B.STATUS
, B.COUNTY
, B.SIC_CODE_TYPE
, B.TOTAL_NUM_OF_ORDERS
, B.TOTAL_ORDERED_AMOUNT
, B.LAST_ORDERED_DATE
, B.URL
, B.EMAIL_ADDRESS
, B.DO_NOT_MAIL_FLAG
, B.ANALYSIS_FY
, B.FISCAL_YEAREND_MONTH
, B.EMPLOYEES_TOTAL
, B.CURR_FY_POTENTIAL_REVENUE
, B.NEXT_FY_POTENTIAL_REVENUE
, B.YEAR_ESTABLISHED
, B.GSA_INDICATOR_FLAG
, B.MISSION_STATEMENT
, B.ORGANIZATION_NAME_PHONETIC
, B.PERSON_FIRST_NAME_PHONETIC
, B.PERSON_LAST_NAME_PHONETIC
, B.LANGUAGE_NAME
, B.CATEGORY_CODE
, B.REFERENCE_USE_FLAG
, B.THIRD_PARTY_FLAG
, B.COMPETITOR_FLAG
, B.SALUTATION
, B.KNOWN_AS2
, B.KNOWN_AS4
, B.KNOWN_AS3
, B.KNOWN_AS5
, C.PARTY_ID
, C.PARTY_NUMBER
, C.PARTY_NAME
, C.VALIDATED_FLAG
, C.PARTY_TYPE
, C.ORIG_SYSTEM_REFERENCE
, C.SIC_CODE
, C.HQ_BRANCH_IND
, C.CUSTOMER_KEY
, C.TAX_REFERENCE
, C.JGZZ_FISCAL_CODE
, C.DUNS_NUMBER
, C.TAX_NAME
, C.PERSON_PRE_NAME_ADJUNCT
, C.PERSON_FIRST_NAME
, C.PERSON_MIDDLE_NAME
, C.PERSON_LAST_NAME
, C.PERSON_NAME_SUFFIX
, C.PERSON_TITLE
, C.PERSON_ACADEMIC_TITLE
, C.PERSON_PREVIOUS_LAST_NAME
, C.KNOWN_AS
, C.PERSON_IDEN_TYPE
, C.PERSON_IDENTIFIER
, C.GROUP_TYPE
, C.COUNTRY
, C.ADDRESS1
, C.ADDRESS2
, C.ADDRESS3
, C.ADDRESS4
, C.CITY
, C.POSTAL_CODE
, C.STATE
, C.PROVINCE
, C.STATUS
, C.COUNTY
, C.SIC_CODE_TYPE
, C.TOTAL_NUM_OF_ORDERS
, C.TOTAL_ORDERED_AMOUNT
, C.LAST_ORDERED_DATE
, C.URL
, C.EMAIL_ADDRESS
, C.DO_NOT_MAIL_FLAG
, C.ANALYSIS_FY
, C.FISCAL_YEAREND_MONTH
, C.EMPLOYEES_TOTAL
, C.CURR_FY_POTENTIAL_REVENUE
, C.NEXT_FY_POTENTIAL_REVENUE
, C.YEAR_ESTABLISHED
, C.GSA_INDICATOR_FLAG
, C.MISSION_STATEMENT
, C.ORGANIZATION_NAME_PHONETIC
, C.PERSON_FIRST_NAME_PHONETIC
, C.PERSON_LAST_NAME_PHONETIC
, C.LANGUAGE_NAME
, C.CATEGORY_CODE
, C.REFERENCE_USE_FLAG
, C.THIRD_PARTY_FLAG
, C.COMPETITOR_FLAG
, C.SALUTATION
, C.KNOWN_AS2
, C.KNOWN_AS3
, C.KNOWN_AS4
, C.KNOWN_AS5
FROM HZ_PARTIES B
, HZ_PARTIES C
, HZ_RELATIONSHIPS A
, AR_LOOKUPS L
WHERE (A.SUBJECT_ID = B.PARTY_ID)
AND (A.OBJECT_ID = C.PARTY_ID)
AND L.LOOKUP_TYPE = 'PARTY_RELATIONS_TYPE'
AND L.LOOKUP_CODE(+) = A.RELATIONSHIP_CODE
AND A.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND A.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND A.DIRECTIONAL_FLAG = 'F'