VIEW: APPS.AMS_DM_ORGANIZATIONS_V

Source

View Text - Preformatted

SELECT p.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, null seeded_target FROM ams_dm_party_details p, ams_dm_party_details_time pt WHERE pt.party_id = p.party_id AND p.party_type = 'PARTY_RELATIONSHIP'

View Text - HTML Formatted

SELECT P.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
, NULL SEEDED_TARGET
FROM AMS_DM_PARTY_DETAILS P
, AMS_DM_PARTY_DETAILS_TIME PT
WHERE PT.PARTY_ID = P.PARTY_ID
AND P.PARTY_TYPE = 'PARTY_RELATIONSHIP'