Search Results sic_code1




Overview
Explore in AI Chat

Overview

AMS_DM_ORGANIZATIONS_V is a view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the AMS (Marketing) product family. It was originally defined to support the seeded data mining data source for organizations and organization contacts within the Trading Community Architecture (TCA), giving marketing analytics and data mining processes a flattened, denormalized projection of party and party-site information along with an extensive set of third-party business, credit, and financial attributes. Oracle's own documentation carries the caveat that the view is no longer used for seeded data sources, a status change dated 15 July 2004. Consequently, in both Oracle EBS 12.1.1 and 12.2.2 the object remains VALID in the database for backward compatibility, but it is not actively maintained as part of the seeded data mining infrastructure. Its practical role today is as a legacy reporting and integration surface for the AMS schema.

Underlying Base Objects

Per the ETRM 12.2.2 metadata, the view is defined over two referenced base objects, both exposed as synonyms: AMS_DM_PARTY_DETAILS and AMS_DM_PARTY_DETAILS_TIME. AMS_DM_PARTY_DETAILS supplies the core party, party site, and organization profile attributes, while AMS_DM_PARTY_DETAILS_TIME contributes time-dependent or period-oriented data used by the original data mining processes. The view itself performs no aggregation or business logic beyond column projection: it simply joins the party detail and time detail records and exposes the combined result set under a single name. Because the underlying objects are synonyms rather than physical tables, the view is tightly coupled to the AMS data mining staging structures; any change to those objects propagates directly to this view.

Key Columns

The view exposes a very wide column list. Identity and contact columns include PARTY_ID, PARTY_NAME, EMAIL_ADDRESS, ADDRESS1, ADDRESS2, CITY, STATE, PROVINCE, ZIP_CODE, and COUNTRY. Person-level fields include PERSON_FIRST_NAME, PERSON_MIDDLE_NAME, PERSON_LAST_NAME, PERSON_NAME_SUFFIX, PERSON_TITLE, and PERSON_ACADEMIC_TITLE. Classification columns such as ORGANIZATION_TYPE, BUSINESS_SCOPE, CORPORATION_CLASS, INCORP_YEAR, LEGAL_STATUS, YEAR_ESTABLISHED, NUM_OF_EMPLOYEES, SIC_CODE1, MINORITY_BUSINESS_FLAG, SMALL_BUSINESS_FLAG, WOMEN_OWNED_BUS_FLAG, and GOV_ORG_FLAG describe the entity itself. Credit and financial columns cover HIGH_CREDIT, TOTAL_PAYMENTS, CREDIT_SCORE_CLASS, CREDIT_SCORE_NATL_PERCENTILE, MAXIMUM_CREDIT_RECOMMENDATION, MAXIMUM_CREDIT_CURRENCY_CODE, DEBT_TO_INCOME_RATIO, NET_WORTH, TOTAL_ASSETS, BANKRUPTCY_FLAG, HIGH_RISK_FRAUD_FLAG, GROSS_ANNUAL_SALES, NET_PROFIT, ACCOUNTS_RECEIVABLE, and DNB_SCORE. Note that the metadata documents these columns but not a PAYMENT_GRACE_DAYS column; the closest related financial indicators are HIGH_CREDIT, TOTAL_PAYMENTS, and the PAYDEX_SCORE_* columns, which reflect payment behavior rather than a grace period.

Common Use Cases and Queries

The view is most useful for extracting organization-level marketing and credit profiles into external analytics or legacy reports, particularly where historical data mining output must be reconciled. Typical queries filter by organization type, credit class, or business scope. For example:

  • SELECT party_id, party_name, organization_type, credit_score_class, high_credit FROM ams_dm_organizations_v WHERE organization_type = 'CUSTOMER';
  • SELECT party_name, gross_annual_sales, num_of_employees, dnb_score FROM ams_dm_organizations_v WHERE gross_annual_sales > 1000000 ORDER BY gross_annual_sales DESC;
  • SELECT party_id, party_name, city, state, country FROM ams_dm_organizations_v WHERE country = 'US' AND small_business_flag = 'Y';

Because the object is no longer supported for seeded data sources, teams building new AMS integrations should confirm whether TCA-based alternatives such as HZ_PARTIES and HZ_ORGANIZATION_PROFILES better serve their requirement, and treat AMS_DM_ORGANIZATIONS_V as a read-only historical artifact.