VIEW: APPS.JTF_HZ_ORGANIZATION_PROFILES_V

Source

View Text - Preformatted

SELECT rowid, organization_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_attribute3, global_attribute4, 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, duns_number, enquiry_duns, ceo_name, ceo_title, principal_name, principal_title, legal_status, control_yr, employees_total, hq_branch_ind, branch_flag, oob_ind, line_of_business, cong_dist_code, sic_code, import_ind, export_ind, labor_surplus_ind, debarment_ind, minority_owned_ind, minority_owned_type, woman_owned_ind, disadv_8a_ind, small_bus_ind, rent_own_ind, debarments_count, debarments_date, failure_score, failure_score_natl_percentile, failure_score_override_code, failure_score_commentary, global_failure_score, db_rating, credit_score, credit_score_commentary, paydex_score, paydex_three_months_ago, paydex_norm, best_time_contact_begin, best_time_contact_end, organization_name_phonetic, tax_name, tax_reference, gsa_indicator_flag, jgzz_fiscal_code, analysis_fy, fiscal_yearend_month, curr_fy_potential_revenue, next_fy_potential_revenue, year_established, mission_statement, organization_type, business_scope, corporation_class, known_as, local_bus_iden_type, local_bus_identifier, pref_functional_currency, last_update_date, last_updated_by, creation_date, created_by, last_update_login, wh_update_date, request_id, program_application_id, program_id, program_update_date FROM HZ_ORGANIZATION_PROFILES WITH READ ONLY

View Text - HTML Formatted

SELECT ROWID
, ORGANIZATION_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_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, 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
, DUNS_NUMBER
, ENQUIRY_DUNS
, CEO_NAME
, CEO_TITLE
, PRINCIPAL_NAME
, PRINCIPAL_TITLE
, LEGAL_STATUS
, CONTROL_YR
, EMPLOYEES_TOTAL
, HQ_BRANCH_IND
, BRANCH_FLAG
, OOB_IND
, LINE_OF_BUSINESS
, CONG_DIST_CODE
, SIC_CODE
, IMPORT_IND
, EXPORT_IND
, LABOR_SURPLUS_IND
, DEBARMENT_IND
, MINORITY_OWNED_IND
, MINORITY_OWNED_TYPE
, WOMAN_OWNED_IND
, DISADV_8A_IND
, SMALL_BUS_IND
, RENT_OWN_IND
, DEBARMENTS_COUNT
, DEBARMENTS_DATE
, FAILURE_SCORE
, FAILURE_SCORE_NATL_PERCENTILE
, FAILURE_SCORE_OVERRIDE_CODE
, FAILURE_SCORE_COMMENTARY
, GLOBAL_FAILURE_SCORE
, DB_RATING
, CREDIT_SCORE
, CREDIT_SCORE_COMMENTARY
, PAYDEX_SCORE
, PAYDEX_THREE_MONTHS_AGO
, PAYDEX_NORM
, BEST_TIME_CONTACT_BEGIN
, BEST_TIME_CONTACT_END
, ORGANIZATION_NAME_PHONETIC
, TAX_NAME
, TAX_REFERENCE
, GSA_INDICATOR_FLAG
, JGZZ_FISCAL_CODE
, ANALYSIS_FY
, FISCAL_YEAREND_MONTH
, CURR_FY_POTENTIAL_REVENUE
, NEXT_FY_POTENTIAL_REVENUE
, YEAR_ESTABLISHED
, MISSION_STATEMENT
, ORGANIZATION_TYPE
, BUSINESS_SCOPE
, CORPORATION_CLASS
, KNOWN_AS
, LOCAL_BUS_IDEN_TYPE
, LOCAL_BUS_IDENTIFIER
, PREF_FUNCTIONAL_CURRENCY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, WH_UPDATE_DATE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM HZ_ORGANIZATION_PROFILES WITH READ ONLY