VIEW: APPS.JTF_PARTY_CUSTOMERS_V

Source

View Text - Preformatted

SELECT PARTY.ROWID , PARTY.PARTY_ID , PARTY.PARTY_ID , PARTY.PARTY_NUMBER , PARTY.PARTY_TYPE , PARTY.LAST_UPDATE_DATE , PARTY.LAST_UPDATED_BY , PARTY.LAST_UPDATE_LOGIN , PARTY.CREATION_DATE , PARTY.CREATED_BY , PARTY.PARTY_NAME , PARTY.ORIG_SYSTEM_REFERENCE , PARTY.SIC_CODE , ORG_PROFILE.ANALYSIS_FY , PARTY.CUSTOMER_KEY , ORG_PROFILE.FISCAL_YEAREND_MONTH , ORG_PROFILE.EMPLOYEES_TOTAL , ORG_PROFILE.CURR_FY_POTENTIAL_REVENUE , ORG_PROFILE.NEXT_FY_POTENTIAL_REVENUE , ORG_PROFILE.TAX_REFERENCE , ORG_PROFILE.YEAR_ESTABLISHED , ORG_PROFILE.ORGANIZATION_NAME_PHONETIC , PARTY.URL , ORG_PROFILE.INTERNAL_FLAG , ORG_PROFILE.LINE_OF_BUSINESS , PARTY.KNOWN_AS , PARTY.PERSON_PRE_NAME_ADJUNCT , PARTY.PERSON_FIRST_NAME , PARTY.PERSON_MIDDLE_NAME , PARTY.PERSON_LAST_NAME , PARTY.PERSON_NAME_SUFFIX , PERSON_PROFILE.DATE_OF_BIRTH , PERSON_PROFILE.PERSON_TITLE , PERSON_PROFILE.PERSON_FIRST_NAME_PHONETIC , PERSON_PROFILE.PERSON_LAST_NAME_PHONETIC , PERSON_PROFILE.PERSONAL_INCOME , PERSON_PROFILE.GENDER , PERSON_PROFILE.MARITAL_STATUS , PARTY.STATUS , PARTY.REQUEST_ID , PARTY.PROGRAM_APPLICATION_ID , PARTY.PROGRAM_ID , PARTY.PROGRAM_UPDATE_DATE , PARTY.ATTRIBUTE_CATEGORY , PARTY.ATTRIBUTE1 , PARTY.ATTRIBUTE2 , PARTY.ATTRIBUTE3 , PARTY.ATTRIBUTE4 , PARTY.ATTRIBUTE5 , PARTY.ATTRIBUTE6 , PARTY.ATTRIBUTE7 , PARTY.ATTRIBUTE8 , PARTY.ATTRIBUTE9 , PARTY.ATTRIBUTE10 , PARTY.ATTRIBUTE11 , PARTY.ATTRIBUTE12 , PARTY.ATTRIBUTE13 , PARTY.ATTRIBUTE14 , PARTY.ATTRIBUTE15 , PARTY.GLOBAL_ATTRIBUTE_CATEGORY , PARTY.GLOBAL_ATTRIBUTE1 , PARTY.GLOBAL_ATTRIBUTE2 , PARTY.GLOBAL_ATTRIBUTE3 , PARTY.GLOBAL_ATTRIBUTE4 , PARTY.GLOBAL_ATTRIBUTE5 , PARTY.GLOBAL_ATTRIBUTE6 , PARTY.GLOBAL_ATTRIBUTE7 , PARTY.GLOBAL_ATTRIBUTE8 , PARTY.GLOBAL_ATTRIBUTE9 , PARTY.GLOBAL_ATTRIBUTE10 , PARTY.GLOBAL_ATTRIBUTE11 , PARTY.GLOBAL_ATTRIBUTE12 , PARTY.GLOBAL_ATTRIBUTE13 , PARTY.GLOBAL_ATTRIBUTE14 , PARTY.GLOBAL_ATTRIBUTE15 , PARTY.GLOBAL_ATTRIBUTE16 , PARTY.GLOBAL_ATTRIBUTE17 , PARTY.GLOBAL_ATTRIBUTE18 , PARTY.GLOBAL_ATTRIBUTE19 , PARTY.GLOBAL_ATTRIBUTE20 FROM HZ_PARTIES PARTY, HZ_ORGANIZATION_PROFILES ORG_PROFILE, HZ_PERSON_PROFILES PERSON_PROFILE WHERE PARTY.PARTY_ID = PERSON_PROFILE.PARTY_ID(+) AND PARTY.PARTY_ID = ORG_PROFILE.PARTY_ID(+)

View Text - HTML Formatted

SELECT PARTY.ROWID
, PARTY.PARTY_ID
, PARTY.PARTY_ID
, PARTY.PARTY_NUMBER
, PARTY.PARTY_TYPE
, PARTY.LAST_UPDATE_DATE
, PARTY.LAST_UPDATED_BY
, PARTY.LAST_UPDATE_LOGIN
, PARTY.CREATION_DATE
, PARTY.CREATED_BY
, PARTY.PARTY_NAME
, PARTY.ORIG_SYSTEM_REFERENCE
, PARTY.SIC_CODE
, ORG_PROFILE.ANALYSIS_FY
, PARTY.CUSTOMER_KEY
, ORG_PROFILE.FISCAL_YEAREND_MONTH
, ORG_PROFILE.EMPLOYEES_TOTAL
, ORG_PROFILE.CURR_FY_POTENTIAL_REVENUE
, ORG_PROFILE.NEXT_FY_POTENTIAL_REVENUE
, ORG_PROFILE.TAX_REFERENCE
, ORG_PROFILE.YEAR_ESTABLISHED
, ORG_PROFILE.ORGANIZATION_NAME_PHONETIC
, PARTY.URL
, ORG_PROFILE.INTERNAL_FLAG
, ORG_PROFILE.LINE_OF_BUSINESS
, PARTY.KNOWN_AS
, PARTY.PERSON_PRE_NAME_ADJUNCT
, PARTY.PERSON_FIRST_NAME
, PARTY.PERSON_MIDDLE_NAME
, PARTY.PERSON_LAST_NAME
, PARTY.PERSON_NAME_SUFFIX
, PERSON_PROFILE.DATE_OF_BIRTH
, PERSON_PROFILE.PERSON_TITLE
, PERSON_PROFILE.PERSON_FIRST_NAME_PHONETIC
, PERSON_PROFILE.PERSON_LAST_NAME_PHONETIC
, PERSON_PROFILE.PERSONAL_INCOME
, PERSON_PROFILE.GENDER
, PERSON_PROFILE.MARITAL_STATUS
, PARTY.STATUS
, PARTY.REQUEST_ID
, PARTY.PROGRAM_APPLICATION_ID
, PARTY.PROGRAM_ID
, PARTY.PROGRAM_UPDATE_DATE
, PARTY.ATTRIBUTE_CATEGORY
, PARTY.ATTRIBUTE1
, PARTY.ATTRIBUTE2
, PARTY.ATTRIBUTE3
, PARTY.ATTRIBUTE4
, PARTY.ATTRIBUTE5
, PARTY.ATTRIBUTE6
, PARTY.ATTRIBUTE7
, PARTY.ATTRIBUTE8
, PARTY.ATTRIBUTE9
, PARTY.ATTRIBUTE10
, PARTY.ATTRIBUTE11
, PARTY.ATTRIBUTE12
, PARTY.ATTRIBUTE13
, PARTY.ATTRIBUTE14
, PARTY.ATTRIBUTE15
, PARTY.GLOBAL_ATTRIBUTE_CATEGORY
, PARTY.GLOBAL_ATTRIBUTE1
, PARTY.GLOBAL_ATTRIBUTE2
, PARTY.GLOBAL_ATTRIBUTE3
, PARTY.GLOBAL_ATTRIBUTE4
, PARTY.GLOBAL_ATTRIBUTE5
, PARTY.GLOBAL_ATTRIBUTE6
, PARTY.GLOBAL_ATTRIBUTE7
, PARTY.GLOBAL_ATTRIBUTE8
, PARTY.GLOBAL_ATTRIBUTE9
, PARTY.GLOBAL_ATTRIBUTE10
, PARTY.GLOBAL_ATTRIBUTE11
, PARTY.GLOBAL_ATTRIBUTE12
, PARTY.GLOBAL_ATTRIBUTE13
, PARTY.GLOBAL_ATTRIBUTE14
, PARTY.GLOBAL_ATTRIBUTE15
, PARTY.GLOBAL_ATTRIBUTE16
, PARTY.GLOBAL_ATTRIBUTE17
, PARTY.GLOBAL_ATTRIBUTE18
, PARTY.GLOBAL_ATTRIBUTE19
, PARTY.GLOBAL_ATTRIBUTE20
FROM HZ_PARTIES PARTY
, HZ_ORGANIZATION_PROFILES ORG_PROFILE
, HZ_PERSON_PROFILES PERSON_PROFILE
WHERE PARTY.PARTY_ID = PERSON_PROFILE.PARTY_ID(+)
AND PARTY.PARTY_ID = ORG_PROFILE.PARTY_ID(+)