[Home] [Help] [Dependency Information]
Object Name: | AMS_DM_ORGANIZATIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_DM_ORGANIZATIONS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARTY_ID | NUMBER | Yes | Party identifier. | |
PARTY_NAME | VARCHAR2 | (360) | Name of this party. | |
EMAIL_ADDRESS | VARCHAR2 | (240) | E-mail address. | |
ADDRESS1 | VARCHAR2 | (240) | First line of address. | |
ADDRESS2 | VARCHAR2 | (240) | Second line of address. | |
CITY | VARCHAR2 | (120) | The city of the party's registered location. | |
STATE | VARCHAR2 | (60) | State. | |
PROVINCE | VARCHAR2 | (60) | Province. | |
ZIP_CODE | VARCHAR2 | (60) | Zip code. | |
COUNTRY | VARCHAR2 | (60) | Country. | |
RENT_FLAG | VARCHAR2 | (1) | Rent indicator. | |
COMPETITOR_FLAG | VARCHAR2 | (240) | Indicates if a party is a competitor. | |
THIRD_PARTY_FLAG | VARCHAR2 | (240) | Tracks if a party has a direct relationship with the organization using Oracle Receivables or through a third party vendor. | |
REFERENCE_USE_FLAG | VARCHAR2 | (1) | Use as a reference indicator. | |
PERSON_FIRST_NAME | VARCHAR2 | (240) | First name of the person. | |
PERSON_MIDDLE_NAME | VARCHAR2 | (240) | Middle name of the person. | |
PERSON_LAST_NAME | VARCHAR2 | (240) | Last or surname of the person. | |
PERSON_NAME_SUFFIX | VARCHAR2 | (240) | Indicates the place in a family structure. For example, in Tom Jones III, the "III" is the suffix. | |
PERSON_TITLE | VARCHAR2 | (240) | A professional or family title. | |
PERSON_ACADEMIC_TITLE | VARCHAR2 | (240) | Academic title that is part of a person's name. | |
PERSON_PRE_NAME_ADJUNCT | VARCHAR2 | (240) | Salutary introduction. | |
CONTROL_YR | NUMBER | Year when current ownership gained control. | ||
LINE_OF_BUSINESS | VARCHAR2 | (30) | Line of business. | |
CONG_DIST_CODE | VARCHAR2 | (240) | U.S. Congressional District. | |
LABOR_SURPLUS_FLAG | VARCHAR2 | (240) | Indicates if this company operates in an area with a labor surplu. | |
DEBARMENT_FLAG | VARCHAR2 | (240) | Indicates if this party is prohibited from entering into contracts or transactions with a government agency in the United States. | |
DISADV_8A_FLAG | VARCHAR2 | (240) | Indicates if this company is considered disadvantaged by the US governement under Title 8A. | |
DEBARMENTS_COUNT | NUMBER | Count of filings by government agencies in the United States that prohibit the party from entering into contracts or transactions with those agencies. | ||
MONTHS_SINCE_LAST_DEBARMENT | NUMBER | Months since the most recent filing to prohibit the party from entering into contracts or transactions with a government agency in the United States. | ||
GSA_INDICATOR_FLAG | VARCHAR2 | (240) | Indicates if this is a US federal agency supported by the General Services Administration (GSA). | |
ANALYSIS_FY | VARCHAR2 | (240) | Fiscal year used as the source for financial information. | |
FISCAL_YEAREND_MONTH | VARCHAR2 | (240) | Month in which fiscal year ends for organization. | |
CURR_FY_POTENTIAL_REVENUE | NUMBER | Organization's potential revenue for this fiscal year. | ||
NEXT_FY_POTENTIAL_REVENUE | NUMBER | Organization's potential revenue for next fiscal year. | ||
ORGANIZATION_TYPE | VARCHAR2 | (240) | User-defined organization types such as region, division, and department. | |
BUSINESS_SCOPE | VARCHAR2 | (240) | The physical class of business in which a business participates. For example, local, national, or international. | |
CORPORATION_CLASS | VARCHAR2 | (240) | Taxation classification for corporation entities. For example, Chapter S in the US. | |
REGISTRATION_TYPE | VARCHAR2 | (240) | Lookup for type of registration, such as nonprofit. | |
INCORP_YEAR | NUMBER | Year that the business was incorporated. | ||
PUBLIC_PRIVATE_OWNERSHIP_FLAG | VARCHAR2 | (240) | Indicates if the organization is privately owned. | |
INTERNAL_FLAG | VARCHAR2 | (240) | Indicates if this is an internal organization. | |
HIGH_CREDIT | NUMBER | High credit. | ||
AVG_HIGH_CREDIT | NUMBER | Average high credit. | ||
TOTAL_PAYMENTS | NUMBER | Total number of payment experiences. | ||
CREDIT_SCORE_CLASS | NUMBER | Measures the risk of severe delinquency by a customer account. The value ranges from 1 for the greatest risk and 5 for the least risk. | ||
CREDIT_SCORE_NATL_PERCENTILE | NUMBER | Indicates the relative credit rating of a business compared to all businesses whose credit ratings are included in the local country database. | ||
CREDIT_SCORE_INCD_DEFAULT | NUMBER | Indicates the probability, expressed as a percentage, of delinquency for a score range or class. | ||
CREDIT_SCORE_AGE | NUMBER | Indicates the age of the credit score, expressed in months. | ||
FAILURE_SCORE_CLASS | NUMBER | The failure score class value measures the risk of financial stress for a customer account. The value range is from 1 to 5. A value of 1 indicates a business that has the greatest risk, and a value of 5 indicates a business that has the least risk. | ||
FAILURE_SCORE_INCD_DEFAULT | NUMBER | The failure score incident value states the probability, expressed as a percentage, of failure for a score range or class. | ||
FAILURE_SCORE_AGE | NUMBER | The failure score age value states the age of the failure score, expressed in months. | ||
MAXIMUM_CREDIT_RECOMMENDATION | NUMBER | Maximum credit limit recommended for a specific currency. | ||
MAXIMUM_CREDIT_CURRENCY_CODE | VARCHAR2 | (240) | Currency used to state the MAXIMUM_CREDIT_RECOMMENDATION column. | |
GROSS_ANNUAL_INCOME | NUMBER | Gross annual income. | ||
DEBT_TO_INCOME_RATIO | NUMBER | Deb to income ratio. | ||
NUM_CREDIT_LINES | NUMBER | Number of credit lines. | ||
NUM_TRADE_LINES | NUMBER | Number of trade lines. | ||
NET_WORTH | NUMBER | Net worth. | ||
TOTAL_ASSETS | NUMBER | Total assets. | ||
TOT_DEBT_OUTSTANDING | NUMBER | Total debt outstanding. | ||
BANKRUPTCY_FLAG | VARCHAR2 | (1) | Bankruptcy indicator. | |
HIGH_RISK_FRAUD_FLAG | VARCHAR2 | (1) | High risk of fraud indicator. | |
GROSS_ANNUAL_SALES | NUMBER | Gross annual sales. | ||
GROWTH_RATE_SALES_YEAR | NUMBER | Growth rate of sales for the past year. | ||
CURRENT_ASSETS | NUMBER | Current assets. | ||
CURRENT_LIABILITIES | NUMBER | Current liabilities. | ||
TOTAL_DEBTS | NUMBER | Total debts. | ||
NET_PROFIT | NUMBER | Net profit. | ||
TANGIBLE_NET_PROFIT | NUMBER | Tangible net profit. | ||
CAPITAL_AMOUNT | NUMBER | Capital amount. | ||
CAPITAL_TYPE_INDICATOR | VARCHAR2 | (30) | Capital type indicator. | |
ACCOUNTS_RECEIVABLE | NUMBER | Accounts receivable. | ||
RETAINED_EARNINGS | NUMBER | Retained earnings. | ||
PAYDEX_SCORE_YEAR | NUMBER | Paydex score for the past year. | ||
PAYDEX_SCORE_3_MONTH_AGO | NUMBER | Paydex score 3 months ago. | ||
INDUSTRY_PAYDEX_MEDIAN | NUMBER | Industry paydex score median. | ||
GLOBAL_FAILURE_SCORE | VARCHAR2 | (5) | Global failure score. | |
DNB_SCORE | VARCHAR2 | (5) | Dunn and Bradstreet score. | |
OUT_OF_BUSINESS_FLAG | VARCHAR2 | (1) | Out of business indicator. | |
CUSTOMER_QUALITY_RANK | NUMBER | Customer quality rank. | ||
FORTUNE_500_RANK | NUMBER | Fortune 500 rank. | ||
NUM_OF_EMPLOYEES | NUMBER | Number of employees. | ||
LEGAL_STATUS | VARCHAR2 | (30) | Legal status. | |
YEAR_ESTABLISHED | NUMBER | Year established. | ||
SIC_CODE1 | VARCHAR2 | (30) | Industry SIC code. | |
MINORITY_BUSINESS_FLAG | VARCHAR2 | (1) | Minority business indicator. | |
SMALL_BUSINESS_FLAG | VARCHAR2 | (1) | Small business indicator. | |
WOMEN_OWNED_BUS_FLAG | VARCHAR2 | (1) | Women owned business indicator. | |
GOV_ORG_FLAG | VARCHAR2 | (1) | Government organization indicator. | |
HQ_SUBSIDIARY_FLAG | VARCHAR2 | (1) | HQ subsidiary indicator. | |
FOREIGN_OWNED_FLAG | VARCHAR2 | (1) | Foreign owned indicator. | |
IMPORT_EXPORT_BUS_FLAG | VARCHAR2 | (1) | Import-Export business indicator. | |
CREDIT_CHECK_FLAG | VARCHAR2 | (1) | Credit check indicator. | |
TOLERANCE | NUMBER | Tolerance. | ||
DISCOUNT_TERMS_FLAG | VARCHAR2 | (1) | Discount terms indicator. | |
DUNNING_LETTERS_FLAG | VARCHAR2 | (1) | Dunning letters indicator. | |
INTEREST_CHARGES_FLAG | VARCHAR2 | (1) | Interest charges indicator. | |
SEND_STATEMENTS_FLAG | VARCHAR2 | (1) | Send statement indicator. | |
CREDIT_HOLD_FLAG | VARCHAR2 | (1) | Credit hold indicator. | |
CREDIT_RATING | VARCHAR2 | (60) | Credit rating. | |
RISK_CODE | VARCHAR2 | (60) | Risk code. | |
INTEREST_PERIOD_DAYS | NUMBER | Number of days in interest period. | ||
PAYMENT_GRACE_DAYS | NUMBER | Number of payment grace days. | ||
DAYS_SINCE_LAST_EVENT | NUMBER | Number of days since last attended an event. | ||
NUM_TIMES_TARGETED | NUMBER | Number of times targeted. | ||
LAST_TARGETED_CHANNEL_CODE | NUMBER | Last targeted channel. | ||
TIMES_TARGETED_MONTH | NUMBER | Number of times targeted in the last month. | ||
TIMES_TARGETED_3_MONTHS | NUMBER | Number of times targeted in the last 3 months. | ||
TIMES_TARGETED_6_MONTHS | NUMBER | Number of times targeted in the last 6 months. | ||
TIMES_TARGETED_12_MONTHS | NUMBER | Number of times targeted in the last 12 months. | ||
DAYS_SINCE_LAST_TARGETED | NUMBER | Number of days since the last time targeted. | ||
AVG_DISC_OFFERED | NUMBER | Average discount offered. | ||
NUM_TYPES_DISC_OFFERED | NUMBER | Number of types of discounts offered. | ||
NUM_TIMES_TARGETED_EMAIL | NUMBER | Number of times targeted by email. | ||
NUM_TIMES_TARGETED_DIRECT | NUMBER | Number of times targeted by direct mail. | ||
NUM_TIMES_TARGETED_TELEMKT | NUMBER | Number of times targeted by telemarketing. | ||
NUM_TGT_BY_OFFR_TYP1 | NUMBER | Number of times targeted by offer 1. | ||
NUM_TGT_BY_OFFR_TYP2 | NUMBER | Number of times targeted by offer 2. | ||
NUM_TGT_BY_OFFR_TYP3 | NUMBER | Number of times targeted by offer 3. | ||
NUM_TGT_BY_OFFR_TYP4 | NUMBER | Number of times targeted by offer 4. | ||
DAYS_SINCE_FIRST_CONTACT | NUMBER | Number of days since the first contact. | ||
AVG_TALK_TIME | NUMBER | Average talk time. | ||
AVG_ORDER_AMOUNT | NUMBER | Average order amount. | ||
AVG_UNITS_PER_ORDER | NUMBER | Averge units per order. | ||
TOT_ORDER_AMOUNT_YEAR | NUMBER | Total order amount in the past year. | ||
TOT_ORDER_AMOUNT_9_MONTHS | NUMBER | Total order amount in the past 9 months. | ||
TOT_ORDER_AMOUNT_6_MONTHS | NUMBER | Total order amount in the past 6 months. | ||
TOT_ORDER_AMOUNT_3_MONTHS | NUMBER | Total order amount in the past 3 months. | ||
TOT_NUM_ORDERS_YEAR | NUMBER | Total number of orders in the past year. | ||
TOT_NUM_ORDER_9_MONTHS | NUMBER | Total number of orders in the past 9 months. | ||
TOT_NUM_ORDER_6_MONTHS | NUMBER | Total number of orders in the past 6 months. | ||
TOT_NUM_ORDER_3_MONTHS | NUMBER | Total number of orders in the past 3 months. | ||
DAYS_SINCE_ACCT_ESTABLISHED | NUMBER | Number of days since account established. | ||
DAYS_SINCE_ACCT_TERM | NUMBER | Number of days since account terms. | ||
DAYS_SINCE_ACCT_ACTIVATION | NUMBER | Number of days since account activation. | ||
DAYS_SINCE_ACCT_SUSPENDED | NUMBER | Number of days since the account was suspended. | ||
NUM_OF_SR_YEAR | NUMBER | Number of service requests in the past year. | ||
NUM_OF_SR_6_MONTHS | NUMBER | Number of service requests in the past 6 months. | ||
NUM_OF_SR_3_MONTHS | NUMBER | Number of service requests in the past 3 months. | ||
NUM_OF_SR_1_MONTH | NUMBER | Number of service requests in the past month. | ||
AVG_RESOLVE_DAYS_YEAR | NUMBER | Average number of days to resolve in the past year. | ||
AVG_RESOLVE_DAYS_6_MONTHS | NUMBER | Average number of days to resolve in the past 6 months. | ||
AVG_RESOLVE_DAYS_3_MONTHS | NUMBER | Average number of days to resolve in the past 3 months. | ||
AVG_RESOLVE_DAYS_1_MONTH | NUMBER | Average number of days to resolve in the past month. | ||
ORDER_LINES_DELIVERED | NUMBER | Number of order lines delivered. | ||
ORDER_LINES_ONTIME | NUMBER | Number of order lines delivered on time. | ||
ORDER_QTY_CUMUL | NUMBER | Cumulative order quantity. | ||
ORDER_RECENCY | NUMBER | Order recency. | ||
PAYMENTS | NUMBER | Payments. | ||
RETURNS | NUMBER | Returns. | ||
RETURN_BY_VALUE | NUMBER | Return by value. | ||
RETURN_BY_VALUE_PCT | NUMBER | Return by percentage value. | ||
ONTIME_PAYMENTS | NUMBER | On time payments. | ||
ONTIME_SHIP_PCT | NUMBER | Ontime ship percentage. | ||
CLOSED_SRS | NUMBER | Closed service requests. | ||
COGS | NUMBER | Cost of goods. | ||
CONTRACTS_CUML | NUMBER | Cumulative contracts. | ||
CONTRACT_AMT | NUMBER | Contract amount. | ||
CONTRACT_DURATION | NUMBER | Contract duration. | ||
INACTIVE_CONTRACTS | NUMBER | Inactive contracts. | ||
OPEN_CONTRACTS | NUMBER | Open contracts. | ||
NEW_CONTRACTS | NUMBER | New contracts. | ||
RENEWED_CONTRACTS | NUMBER | Renewed contracts. | ||
ESCALATED_SRS | NUMBER | Escalated service requests. | ||
FIRST_CALL_CL_RATE | NUMBER | First call close rate. | ||
NUM_OF_COMPLAINTS | NUMBER | Number of complaints. | ||
NUM_OF_INTERACTIONS | NUMBER | Number of interactions. | ||
NUM_OF_TRANSFERS | NUMBER | Number of transfers. | ||
OPEN_SRS | NUMBER | Open service requests. | ||
PCT_CALL_REWORK | NUMBER | Percentage of calls reworked. | ||
PRODUCTS | NUMBER | Products. | ||
REFERALS | NUMBER | Referrals. | ||
REOPENED_SRS | NUMBER | Re-opened service requests. | ||
SALES | NUMBER | Sales. | ||
TOTAL_SR_RESPONSE_TIME | NUMBER | Total service request response time. | ||
PCT_FIRST_CLOSED_SRS | NUMBER | Percentage of first closed service requests. | ||
AVG_COMPLAINTS | NUMBER | Average complaints. | ||
AVG_HOLD_TIME | NUMBER | Average hold time. | ||
AVG_LEN_OF_EMP | NUMBER | Average length of employment. | ||
AVG_TRANSFERS_PER_SR | NUMBER | Average transfers per service request. | ||
AVG_WORKLOAD | NUMBER | Average workload. | ||
TOT_CALLS | NUMBER | Total calls. | ||
CALL_LENGTH | NUMBER | Call length. | ||
PROFITABILITY | NUMBER | Profitability. | ||
SEEDED_TARGET | VARCHAR2 | (0) | Dummy column used for programmatic identification of seeded data mining data sources and target fields. Not intended for use by customers. |
Cut, paste (and edit) the following text to query this object:
SELECT PARTY_ID
, PARTY_NAME
, EMAIL_ADDRESS
, ADDRESS1
, ADDRESS2
, CITY
, STATE
, PROVINCE
, ZIP_CODE
, COUNTRY
, RENT_FLAG
, COMPETITOR_FLAG
, THIRD_PARTY_FLAG
, REFERENCE_USE_FLAG
, PERSON_FIRST_NAME
, PERSON_MIDDLE_NAME
, PERSON_LAST_NAME
, PERSON_NAME_SUFFIX
, PERSON_TITLE
, PERSON_ACADEMIC_TITLE
, PERSON_PRE_NAME_ADJUNCT
, CONTROL_YR
, LINE_OF_BUSINESS
, CONG_DIST_CODE
, LABOR_SURPLUS_FLAG
, DEBARMENT_FLAG
, DISADV_8A_FLAG
, DEBARMENTS_COUNT
, MONTHS_SINCE_LAST_DEBARMENT
, GSA_INDICATOR_FLAG
, ANALYSIS_FY
, FISCAL_YEAREND_MONTH
, CURR_FY_POTENTIAL_REVENUE
, NEXT_FY_POTENTIAL_REVENUE
, ORGANIZATION_TYPE
, BUSINESS_SCOPE
, CORPORATION_CLASS
, REGISTRATION_TYPE
, INCORP_YEAR
, PUBLIC_PRIVATE_OWNERSHIP_FLAG
, INTERNAL_FLAG
, HIGH_CREDIT
, AVG_HIGH_CREDIT
, TOTAL_PAYMENTS
, CREDIT_SCORE_CLASS
, CREDIT_SCORE_NATL_PERCENTILE
, CREDIT_SCORE_INCD_DEFAULT
, CREDIT_SCORE_AGE
, FAILURE_SCORE_CLASS
, FAILURE_SCORE_INCD_DEFAULT
, FAILURE_SCORE_AGE
, MAXIMUM_CREDIT_RECOMMENDATION
, MAXIMUM_CREDIT_CURRENCY_CODE
, GROSS_ANNUAL_INCOME
, DEBT_TO_INCOME_RATIO
, NUM_CREDIT_LINES
, NUM_TRADE_LINES
, NET_WORTH
, TOTAL_ASSETS
, TOT_DEBT_OUTSTANDING
, BANKRUPTCY_FLAG
, HIGH_RISK_FRAUD_FLAG
, GROSS_ANNUAL_SALES
, GROWTH_RATE_SALES_YEAR
, CURRENT_ASSETS
, CURRENT_LIABILITIES
, TOTAL_DEBTS
, NET_PROFIT
, TANGIBLE_NET_PROFIT
, CAPITAL_AMOUNT
, CAPITAL_TYPE_INDICATOR
, ACCOUNTS_RECEIVABLE
, RETAINED_EARNINGS
, PAYDEX_SCORE_YEAR
, PAYDEX_SCORE_3_MONTH_AGO
, INDUSTRY_PAYDEX_MEDIAN
, GLOBAL_FAILURE_SCORE
, DNB_SCORE
, OUT_OF_BUSINESS_FLAG
, CUSTOMER_QUALITY_RANK
, FORTUNE_500_RANK
, NUM_OF_EMPLOYEES
, LEGAL_STATUS
, YEAR_ESTABLISHED
, SIC_CODE1
, MINORITY_BUSINESS_FLAG
, SMALL_BUSINESS_FLAG
, WOMEN_OWNED_BUS_FLAG
, GOV_ORG_FLAG
, HQ_SUBSIDIARY_FLAG
, FOREIGN_OWNED_FLAG
, IMPORT_EXPORT_BUS_FLAG
, CREDIT_CHECK_FLAG
, TOLERANCE
, DISCOUNT_TERMS_FLAG
, DUNNING_LETTERS_FLAG
, INTEREST_CHARGES_FLAG
, SEND_STATEMENTS_FLAG
, CREDIT_HOLD_FLAG
, CREDIT_RATING
, RISK_CODE
, INTEREST_PERIOD_DAYS
, PAYMENT_GRACE_DAYS
, DAYS_SINCE_LAST_EVENT
, NUM_TIMES_TARGETED
, LAST_TARGETED_CHANNEL_CODE
, TIMES_TARGETED_MONTH
, TIMES_TARGETED_3_MONTHS
, TIMES_TARGETED_6_MONTHS
, TIMES_TARGETED_12_MONTHS
, DAYS_SINCE_LAST_TARGETED
, AVG_DISC_OFFERED
, NUM_TYPES_DISC_OFFERED
, NUM_TIMES_TARGETED_EMAIL
, NUM_TIMES_TARGETED_DIRECT
, NUM_TIMES_TARGETED_TELEMKT
, NUM_TGT_BY_OFFR_TYP1
, NUM_TGT_BY_OFFR_TYP2
, NUM_TGT_BY_OFFR_TYP3
, NUM_TGT_BY_OFFR_TYP4
, DAYS_SINCE_FIRST_CONTACT
, AVG_TALK_TIME
, AVG_ORDER_AMOUNT
, AVG_UNITS_PER_ORDER
, TOT_ORDER_AMOUNT_YEAR
, TOT_ORDER_AMOUNT_9_MONTHS
, TOT_ORDER_AMOUNT_6_MONTHS
, TOT_ORDER_AMOUNT_3_MONTHS
, TOT_NUM_ORDERS_YEAR
, TOT_NUM_ORDER_9_MONTHS
, TOT_NUM_ORDER_6_MONTHS
, TOT_NUM_ORDER_3_MONTHS
, DAYS_SINCE_ACCT_ESTABLISHED
, DAYS_SINCE_ACCT_TERM
, DAYS_SINCE_ACCT_ACTIVATION
, DAYS_SINCE_ACCT_SUSPENDED
, NUM_OF_SR_YEAR
, NUM_OF_SR_6_MONTHS
, NUM_OF_SR_3_MONTHS
, NUM_OF_SR_1_MONTH
, AVG_RESOLVE_DAYS_YEAR
, AVG_RESOLVE_DAYS_6_MONTHS
, AVG_RESOLVE_DAYS_3_MONTHS
, AVG_RESOLVE_DAYS_1_MONTH
, ORDER_LINES_DELIVERED
, ORDER_LINES_ONTIME
, ORDER_QTY_CUMUL
, ORDER_RECENCY
, PAYMENTS
, RETURNS
, RETURN_BY_VALUE
, RETURN_BY_VALUE_PCT
, ONTIME_PAYMENTS
, ONTIME_SHIP_PCT
, CLOSED_SRS
, COGS
, CONTRACTS_CUML
, CONTRACT_AMT
, CONTRACT_DURATION
, INACTIVE_CONTRACTS
, OPEN_CONTRACTS
, NEW_CONTRACTS
, RENEWED_CONTRACTS
, ESCALATED_SRS
, FIRST_CALL_CL_RATE
, NUM_OF_COMPLAINTS
, NUM_OF_INTERACTIONS
, NUM_OF_TRANSFERS
, OPEN_SRS
, PCT_CALL_REWORK
, PRODUCTS
, REFERALS
, REOPENED_SRS
, SALES
, TOTAL_SR_RESPONSE_TIME
, PCT_FIRST_CLOSED_SRS
, AVG_COMPLAINTS
, AVG_HOLD_TIME
, AVG_LEN_OF_EMP
, AVG_TRANSFERS_PER_SR
, AVG_WORKLOAD
, TOT_CALLS
, CALL_LENGTH
, PROFITABILITY
, SEEDED_TARGET
FROM APPS.AMS_DM_ORGANIZATIONS_V;
APPS.AMS_DM_ORGANIZATIONS_V is not referenced by any database object
|
|
|