VIEW: APPS.AMS_LT_ORG_PROFILES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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