View: AMS_LT_ORG_PROFILES_V

Product:	AMS - Marketing
Description:	Data Source view based on hz_organization_profiles
Implementation/DBA Data:	APPS.AMS_LT_ORG_PROFILES_V

View Text

SELECT HOP.PARTY_ID
, HOP.CEO_NAME
, HOP.CEO_TITLE
, HOP.LEGAL_STATUS
, HOP.CONTROL_YR
, HOP.EMPLOYEES_TOTAL
, HOP.HQ_BRANCH_IND
, HOP.BRANCH_FLAG
, HOP.OOB_IND
, HOP.LINE_OF_BUSINESS
, HOP.CONG_DIST_CODE
, HOP.SIC_CODE
, HOP.SIC_CODE_TYPE
, HOP.IMPORT_IND
, HOP.EXPORT_IND
, HOP.MINORITY_OWNED_IND
, HOP.MINORITY_OWNED_TYPE
, HOP.WOMAN_OWNED_IND
, HOP.DISADV_8A_IND
, HOP.SMALL_BUS_IND
, HOP.RENT_OWN_IND
, HOP.FAILURE_SCORE
, HOP.FAILURE_SCORE_OVERRIDE_CODE
, HOP.FAILURE_SCORE_COMMENTARY
, HOP.GLOBAL_FAILURE_SCORE
, HOP.DB_RATING
, HOP.CREDIT_SCORE
, HOP.PAYDEX_SCORE
, HOP.PAYDEX_THREE_MONTHS_AGO
, HOP.FISCAL_YEAREND_MONTH
, HOP.CURR_FY_POTENTIAL_REVENUE
, HOP.NEXT_FY_POTENTIAL_REVENUE
, HOP.YEAR_ESTABLISHED
, HOP.ORGANIZATION_TYPE
, HOP.CORPORATION_CLASS
, HOP.LOCAL_BUS_IDEN_TYPE
, HOP.LOCAL_BUS_IDENTIFIER
, HOP.PREF_FUNCTIONAL_CURRENCY
, HOP.REGISTRATION_TYPE
, HOP.TOTAL_EMPLOYEES_TEXT
, HOP.TOTAL_EMPLOYEES_IND
, HOP.TOTAL_EMP_EST_IND
, HOP.TOTAL_EMP_MIN_IND
, HOP.PARENT_SUB_IND
, HOP.INCORP_YEAR
, HOP.PUBLIC_PRIVATE_OWNERSHIP_FLAG
, HOP.EMP_AT_PRIMARY_ADR
, HOP.EMP_AT_PRIMARY_ADR_TEXT
, HOP.EMP_AT_PRIMARY_ADR_EST_IND
, HOP.EMP_AT_PRIMARY_ADR_MIN_IND
, HOP.INTERNAL_FLAG
, HOP.HIGH_CREDIT
, HOP.AVG_HIGH_CREDIT
, HOP.TOTAL_PAYMENTS
, HOP.CONTENT_SOURCE_NUMBER
, HOP.BUSINESS_SCOPE
, HOP.ENQUIRY_DUNS
, HOP.LABOR_SURPLUS_IND
, HOP.PRINCIPAL_NAME
, HOP.PRINCIPAL_TITLE
, HOP.DEBARMENT_IND
, HOP.DEBARMENTS_COUNT
, HOP.DEBARMENTS_DATE
, HOP.LOCAL_ACTIVITY_CODE_TYPE
, HOP.LOCAL_ACTIVITY_CODE
, HOP.CREDIT_SCORE_CLASS
, HOP.CREDIT_SCORE_NATL_PERCENTILE
, HOP.CREDIT_SCORE_INCD_DEFAULT
, HOP.CREDIT_SCORE_AGE
, HOP.CREDIT_SCORE_DATE
, HOP.FAILURE_SCORE_CLASS
, HOP.FAILURE_SCORE_INCD_DEFAULT
, HOP.FAILURE_SCORE_AGE
, HOP.FAILURE_SCORE_DATE
, HOP.MAXIMUM_CREDIT_RECOMMENDATION
, HOP.MAXIMUM_CREDIT_CURRENCY_CODE
, HOP.DISPLAYED_DUNS_PARTY_ID
, HOP.FAILURE_SCORE_NATNL_PERCENTILE
, HOP.BUSINESS_REPORT
FROM HZ_ORGANIZATION_PROFILES HOP
WHERE DECODE(HOP.STATUS
, 'A'
, 1
, 'I'
, 1
, NULL
, 1
, -99) = 1

Columns