VIEW: APPS.AMS_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 ,a.CEO_NAME ,a.CEO_TITLE ,a.TAX_REFERENCE ,a.TAX_NAME ,a.JGZZ_FISCAL_CODE ,a.SIC_CODE ,a.SIC_CODE_TYPE ,a.MINORITY_OWNED_TYPE ,a.GSA_INDICATOR_FLAG ,a.ANALYSIS_FY ,a.FISCAL_YEAREND_MONTH ,a.CURR_FY_POTENTIAL_REVENUE ,a.NEXT_FY_POTENTIAL_REVENUE ,a.CONTENT_SOURCE_NUMBER ,a.BUSINESS_SCOPE ,a.LABOR_SURPLUS_IND ,a.BUSINESS_REPORT FROM HZ_ORGANIZATION_PROFILES A WHERE A.EFFECTIVE_END_DATE IS NULL AND A.ACTUAL_CONTENT_SOURCE = 'SST'

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
, A.CEO_NAME
, A.CEO_TITLE
, A.TAX_REFERENCE
, A.TAX_NAME
, A.JGZZ_FISCAL_CODE
, A.SIC_CODE
, A.SIC_CODE_TYPE
, A.MINORITY_OWNED_TYPE
, A.GSA_INDICATOR_FLAG
, A.ANALYSIS_FY
, A.FISCAL_YEAREND_MONTH
, A.CURR_FY_POTENTIAL_REVENUE
, A.NEXT_FY_POTENTIAL_REVENUE
, A.CONTENT_SOURCE_NUMBER
, A.BUSINESS_SCOPE
, A.LABOR_SURPLUS_IND
, A.BUSINESS_REPORT
FROM HZ_ORGANIZATION_PROFILES A
WHERE A.EFFECTIVE_END_DATE IS NULL
AND A.ACTUAL_CONTENT_SOURCE = 'SST'