VIEW: APPS.AMS_P_ORG_PROFILES_V

Source

View Text - Preformatted

SELECT ORGANIZATION_PROFILE_ID AMS_ORG_PROFILE_ID ,PARTY_ID ,ORGANIZATION_NAME ,ATTRIBUTE_CATEGORY ,ATTRIBUTE1 ,ATTRIBUTE2 ,ATTRIBUTE3 ,ATTRIBUTE4 ,ATTRIBUTE5 ,ATTRIBUTE6 ,ATTRIBUTE7 ,ATTRIBUTE8 ,ATTRIBUTE9 ,ATTRIBUTE10 ,ATTRIBUTE11 ,ATTRIBUTE12 ,ATTRIBUTE13 ,ATTRIBUTE14 ,ATTRIBUTE15 ,ATTRIBUTE16 ,ATTRIBUTE17 ,ATTRIBUTE18 ,ATTRIBUTE19 ,ATTRIBUTE20 ,GLOBAL_ATTRIBUTE_CATEGORY ,GLOBAL_ATTRIBUTE1 ,GLOBAL_ATTRIBUTE2 ,GLOBAL_ATTRIBUTE4 ,GLOBAL_ATTRIBUTE3 ,GLOBAL_ATTRIBUTE5 ,GLOBAL_ATTRIBUTE6 ,GLOBAL_ATTRIBUTE7 ,GLOBAL_ATTRIBUTE8 ,GLOBAL_ATTRIBUTE9 ,GLOBAL_ATTRIBUTE10 ,GLOBAL_ATTRIBUTE11 ,GLOBAL_ATTRIBUTE12 ,GLOBAL_ATTRIBUTE13 ,GLOBAL_ATTRIBUTE14 ,GLOBAL_ATTRIBUTE15 ,GLOBAL_ATTRIBUTE16 ,GLOBAL_ATTRIBUTE17 ,GLOBAL_ATTRIBUTE18 ,GLOBAL_ATTRIBUTE19 ,GLOBAL_ATTRIBUTE20 ,LEGAL_STATUS ,CONTROL_YR ,EMPLOYEES_TOTAL ,HQ_BRANCH_IND ,BRANCH_FLAG ,OOB_IND ,LINE_OF_BUSINESS ,CONG_DIST_CODE ,IMPORT_IND ,EXPORT_IND ,MINORITY_OWNED_IND ,WOMAN_OWNED_IND ,DISADV_8A_IND ,SMALL_BUS_IND ,RENT_OWN_IND ,FAILURE_SCORE ,FAILURE_SCORE_NATL_PERCENTILE ,FAILURE_SCORE_OVERRIDE_CODE ,FAILURE_SCORE_COMMENTARY ,GLOBAL_FAILURE_SCORE ,DB_RATING ,CREDIT_SCORE ,PAYDEX_SCORE ,PAYDEX_THREE_MONTHS_AGO ,PAYDEX_NORM ,BEST_TIME_CONTACT_BEGIN ,BEST_TIME_CONTACT_END ,YEAR_ESTABLISHED ,ORGANIZATION_TYPE ,CORPORATION_CLASS ,KNOWN_AS ,LOCAL_BUS_IDEN_TYPE ,LOCAL_BUS_IDENTIFIER ,PREF_FUNCTIONAL_CURRENCY ,REGISTRATION_TYPE ,TOTAL_EMPLOYEES_TEXT ,TOTAL_EMP_EST_IND ,TOTAL_EMP_MIN_IND ,PARENT_SUB_IND ,INCORP_YEAR ,PUBLIC_PRIVATE_OWNERSHIP_FLAG ,EMP_AT_PRIMARY_ADR ,EMP_AT_PRIMARY_ADR_TEXT ,EMP_AT_PRIMARY_ADR_EST_IND ,EMP_AT_PRIMARY_ADR_MIN_IND ,INTERNAL_FLAG ,HIGH_CREDIT ,AVG_HIGH_CREDIT ,TOTAL_PAYMENTS FROM HZ_ORGANIZATION_PROFILES A WHERE A.ORGANIZATION_PROFILE_ID IN (SELECT MAX(B.ORGANIZATION_PROFILE_ID ) FROM HZ_ORGANIZATION_PROFILES B WHERE B.PARTY_ID = A.PARTY_ID )

View Text - HTML Formatted

SELECT ORGANIZATION_PROFILE_ID AMS_ORG_PROFILE_ID
, PARTY_ID
, ORGANIZATION_NAME
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, LEGAL_STATUS
, CONTROL_YR
, EMPLOYEES_TOTAL
, HQ_BRANCH_IND
, BRANCH_FLAG
, OOB_IND
, LINE_OF_BUSINESS
, CONG_DIST_CODE
, IMPORT_IND
, EXPORT_IND
, MINORITY_OWNED_IND
, WOMAN_OWNED_IND
, DISADV_8A_IND
, SMALL_BUS_IND
, RENT_OWN_IND
, FAILURE_SCORE
, FAILURE_SCORE_NATL_PERCENTILE
, FAILURE_SCORE_OVERRIDE_CODE
, FAILURE_SCORE_COMMENTARY
, GLOBAL_FAILURE_SCORE
, DB_RATING
, CREDIT_SCORE
, PAYDEX_SCORE
, PAYDEX_THREE_MONTHS_AGO
, PAYDEX_NORM
, BEST_TIME_CONTACT_BEGIN
, BEST_TIME_CONTACT_END
, YEAR_ESTABLISHED
, ORGANIZATION_TYPE
, CORPORATION_CLASS
, KNOWN_AS
, LOCAL_BUS_IDEN_TYPE
, LOCAL_BUS_IDENTIFIER
, PREF_FUNCTIONAL_CURRENCY
, REGISTRATION_TYPE
, TOTAL_EMPLOYEES_TEXT
, TOTAL_EMP_EST_IND
, TOTAL_EMP_MIN_IND
, PARENT_SUB_IND
, INCORP_YEAR
, PUBLIC_PRIVATE_OWNERSHIP_FLAG
, EMP_AT_PRIMARY_ADR
, EMP_AT_PRIMARY_ADR_TEXT
, EMP_AT_PRIMARY_ADR_EST_IND
, EMP_AT_PRIMARY_ADR_MIN_IND
, INTERNAL_FLAG
, HIGH_CREDIT
, AVG_HIGH_CREDIT
, TOTAL_PAYMENTS
FROM HZ_ORGANIZATION_PROFILES A
WHERE A.ORGANIZATION_PROFILE_ID IN (SELECT MAX(B.ORGANIZATION_PROFILE_ID )
FROM HZ_ORGANIZATION_PROFILES B
WHERE B.PARTY_ID = A.PARTY_ID )