eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: AMS.AMS_DM_PARTY_DETAILS#

Object Details

Object Name:	AMS_DM_PARTY_DETAILS#
Object Type:	VIEW
Owner:	AMS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
PARTY_ID	NUMBER		Yes
CREATED_BY	NUMBER
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER
OBJECT_VERSION_NUMBER	NUMBER
SECURITY_GROUP_ID	NUMBER
PARTY_TYPE	VARCHAR2	(30)
GENDER	VARCHAR2	(30)
ETHNICITY	VARCHAR2	(60)
MARITAL_STATUS	VARCHAR2	(30)
PERSONAL_INCOME	NUMBER
HOH_FLAG	VARCHAR2	(1)
HOUSEHOLD_INCOME	NUMBER
HOUSEHOLD_SIZE	NUMBER
APARTMENT_FLAG	VARCHAR2	(1)
RENT_FLAG	VARCHAR2	(1)
DEGREE_RECEIVED	VARCHAR2	(1)
SCHOOL_TYPE	VARCHAR2	(60)
INTEREST_ART_FLAG	VARCHAR2	(1)
INTEREST_BOOKS_FLAG	VARCHAR2	(1)
INTEREST_MOVIES_FLAG	VARCHAR2	(1)
INTEREST_MUSIC_FLAG	VARCHAR2	(1)
INTEREST_THEATER_FLAG	VARCHAR2	(1)
INTEREST_TRAVEL_FLAG	VARCHAR2	(1)
INTEREST_DRINK_FLAG	VARCHAR2	(1)
INTEREST_SMOKE_FLAG	VARCHAR2	(1)
INTEREST_OTHER_FLAG	VARCHAR2	(1)
LEVEL_OF_INTEREST	VARCHAR2	(30)
INTEREST_TYPE_CODE	VARCHAR2	(30)
HOBBIES	VARCHAR2	(240)
EXPERIENCE_LEVEL	VARCHAR2	(60)
WORK_CLASS_NAME	VARCHAR2	(240)
EMPLOYED_FLAG	VARCHAR2	(1)
YEARS_EMPLOYED	NUMBER
OCCUPATION	VARCHAR2	(60)
MILITARY_BRANCH	VARCHAR2	(80)
RESIDENCE_TYPE	VARCHAR2	(30)
RESIDENT_LENGTH	NUMBER
SECOND_HOME_TYPE	VARCHAR2	(30)
PRESENCE_OF_CHILDREN	NUMBER
COUNTRY	VARCHAR2	(60)
STATE	VARCHAR2	(60)
PROVINCE	VARCHAR2	(60)
COUNTY	VARCHAR2	(60)
ZIP_CODE	VARCHAR2	(60)
AVG_NUM_LIFE_CYCLE_SEGS	NUMBER
CONTACT_TYPE	VARCHAR2	(30)
CATEGORY_CODE	VARCHAR2	(30)
REFERENCE_USE_FLAG	VARCHAR2	(1)
SUBCATEGORY_CODE	VARCHAR2	(30)
RETURN_TYPE	VARCHAR2	(30)
RETURN_REASON_CODE	VARCHAR2	(30)
REFUND_PRICE	NUMBER
REFUND_TYPE	VARCHAR2	(30)
RETURNED_REASON	VARCHAR2	(120)
GROSS_ANNUAL_INCOME	NUMBER
DEBT_TO_INCOME_RATIO	NUMBER
NUM_CREDIT_LINES	NUMBER
NUM_TRADE_LINES	NUMBER
NET_WORTH	NUMBER
TOTAL_ASSETS	NUMBER
TOT_DEBT_OUTSTANDING	NUMBER
BANKRUPTCY_FLAG	VARCHAR2	(1)
HIGH_RISK_FRAUD_FLAG	VARCHAR2	(1)
GROSS_ANNUAL_SALES	NUMBER
GROWTH_RATE_SALES_YEAR	NUMBER
GROWTH_RATE_NET_PROF_YEAR	NUMBER
CURRENT_ASSETS	NUMBER
CURRENT_LIABILITIES	NUMBER
TOTAL_DEBTS	NUMBER
NET_PROFIT	NUMBER
TANGIBLE_NET_PROFIT	NUMBER
CAPITAL_AMOUNT	NUMBER
CAPITAL_TYPE_INDICATOR	VARCHAR2	(30)
ACCOUNTS_RECEIVABLE	NUMBER
RETAINED_EARNINGS	NUMBER
PAYDEX_SCORE_YEAR	NUMBER
PAYDEX_SCORE_3_MONTH_AGO	NUMBER
INDUSTRY_PAYDEX_MEDIAN	NUMBER
AVG_HIGH_CREDIT	NUMBER
HIGH_CREDIT	NUMBER
TOT_PAYMENT_EXP	NUMBER
NUM_NEGATIVE_PAYMENT	NUMBER
AVG_PAYMENT_SIZE	NUMBER
NUM_SLOW_PAYMENTS	NUMBER
FAILURE_SCORE	NUMBER
FAILURE_SCORE_OVER_CODE	VARCHAR2	(30)
FAILURE_SCORE_INDUSTRY_PCT	NUMBER
FAILURE_SCORE_6_MONTHS	NUMBER
GLOBAL_FAILURE_SCORE	VARCHAR2	(5)
DNB_SCORE	VARCHAR2	(5)
BUSINESS_FAILURE	VARCHAR2	(120)
OUT_OF_BUSINESS_FLAG	VARCHAR2	(1)
CUSTOMER_QUALITY_RANK	NUMBER
FORTUNE_500_RANK	NUMBER
NUM_OF_EMPLOYEES	NUMBER
LEGAL_STATUS	VARCHAR2	(30)
ENTITY_TYPE	VARCHAR2	(30)
YEAR_ESTABLISHED	NUMBER
LINE_OF_BUSINESS	VARCHAR2	(30)
SIC_CODE1	VARCHAR2	(30)
SIC_CODE2	VARCHAR2	(30)
MARKET_SEGMENT_NAME	VARCHAR2	(120)
MARKET_SEGMENT_ID	NUMBER
SITE_NAME	VARCHAR2	(120)
SITE_DUNS_NUMBER	NUMBER
NUM_EMPLOYEES_AT_SITE	NUMBER
MINORITY_BUSINESS_FLAG	VARCHAR2	(1)
SMALL_BUSINESS_FLAG	VARCHAR2	(1)
WOMEN_OWNED_BUS_FLAG	VARCHAR2	(1)
GOV_ORG_FLAG	VARCHAR2	(1)
HQ_SUBSIDIARY_FLAG	VARCHAR2	(1)
FOREIGN_OWNED_FLAG	VARCHAR2	(1)
IMPORT_EXPORT_BUS_FLAG	VARCHAR2	(1)
CREDIT_CHECK_FLAG	VARCHAR2	(1)
TOLERANCE	NUMBER
DISCOUNT_TERMS_FLAG	VARCHAR2	(1)
DUNNING_LETTERS_FLAG	VARCHAR2	(1)
INTEREST_CHARGES_FLAG	VARCHAR2	(1)
SEND_STATEMENTS_FLAG	VARCHAR2	(1)
CREDIT_HOLD_FLAG	VARCHAR2	(1)
CREDIT_RATING	VARCHAR2	(60)
RISK_CODE	VARCHAR2	(60)
INTEREST_PERIOD_DAYS	NUMBER
PAYMENT_GRACE_DAYS	NUMBER
BUSINESS_SCOPE	VARCHAR2	(240)
EMAIL_ADDRESS	VARCHAR2	(240)
ADDRESS1	VARCHAR2	(240)
ADDRESS2	VARCHAR2	(240)
COMPETITOR_FLAG	VARCHAR2	(240)
THIRD_PARTY_FLAG	VARCHAR2	(240)
PERSON_FIRST_NAME	VARCHAR2	(240)
PERSON_MIDDLE_NAME	VARCHAR2	(240)
PERSON_LAST_NAME	VARCHAR2	(240)
PERSON_NAME_SUFFIX	VARCHAR2	(240)
PERSON_TITLE	VARCHAR2	(240)
PERSON_ACADEMIC_TITLE	VARCHAR2	(240)
PERSON_PRE_NAME_ADJUNCT	VARCHAR2	(240)
CONTROL_YR	NUMBER
CONG_DIST_CODE	VARCHAR2	(240)
LABOR_SURPLUS_FLAG	VARCHAR2	(240)
DEBARMENT_FLAG	VARCHAR2	(240)
DISADV_8A_FLAG	VARCHAR2	(240)
DEBARMENTS_COUNT	NUMBER
MONTHS_SINCE_LAST_DEBARMENT	NUMBER
GSA_INDICATOR_FLAG	VARCHAR2	(240)
ANALYSIS_FY	VARCHAR2	(240)
FISCAL_YEAREND_MONTH	VARCHAR2	(240)
CURR_FY_POTENTIAL_REVENUE	NUMBER
NEXT_FY_POTENTIAL_REVENUE	NUMBER
ORGANIZATION_TYPE	VARCHAR2	(240)
CORPORATION_CLASS	VARCHAR2	(240)
REGISTRATION_TYPE	VARCHAR2	(240)
INCORP_YEAR	NUMBER
PUBLIC_PRIVATE_OWNERSHIP_FLAG	VARCHAR2	(240)
INTERNAL_FLAG	VARCHAR2	(240)
TOTAL_PAYMENTS	NUMBER
CREDIT_SCORE_CLASS	NUMBER
CREDIT_SCORE_NATL_PERCENTILE	NUMBER
CREDIT_SCORE_INCD_DEFAULT	NUMBER
CREDIT_SCORE_AGE	NUMBER
FAILURE_SCORE_CLASS	NUMBER
FAILURE_SCORE_INCD_DEFAULT	NUMBER
FAILURE_SCORE_AGE	NUMBER
MAXIMUM_CREDIT_RECOMMENDATION	NUMBER
MAXIMUM_CREDIT_CURRENCY_CODE	VARCHAR2	(240)
PARTY_NAME	VARCHAR2	(360)
CITY	VARCHAR2	(120)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PARTY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      PARTY_TYPE
,      GENDER
,      ETHNICITY
,      MARITAL_STATUS
,      PERSONAL_INCOME
,      HOH_FLAG
,      HOUSEHOLD_INCOME
,      HOUSEHOLD_SIZE
,      APARTMENT_FLAG
,      RENT_FLAG
,      DEGREE_RECEIVED
,      SCHOOL_TYPE
,      INTEREST_ART_FLAG
,      INTEREST_BOOKS_FLAG
,      INTEREST_MOVIES_FLAG
,      INTEREST_MUSIC_FLAG
,      INTEREST_THEATER_FLAG
,      INTEREST_TRAVEL_FLAG
,      INTEREST_DRINK_FLAG
,      INTEREST_SMOKE_FLAG
,      INTEREST_OTHER_FLAG
,      LEVEL_OF_INTEREST
,      INTEREST_TYPE_CODE
,      HOBBIES
,      EXPERIENCE_LEVEL
,      WORK_CLASS_NAME
,      EMPLOYED_FLAG
,      YEARS_EMPLOYED
,      OCCUPATION
,      MILITARY_BRANCH
,      RESIDENCE_TYPE
,      RESIDENT_LENGTH
,      SECOND_HOME_TYPE
,      PRESENCE_OF_CHILDREN
,      COUNTRY
,      STATE
,      PROVINCE
,      COUNTY
,      ZIP_CODE
,      AVG_NUM_LIFE_CYCLE_SEGS
,      CONTACT_TYPE
,      CATEGORY_CODE
,      REFERENCE_USE_FLAG
,      SUBCATEGORY_CODE
,      RETURN_TYPE
,      RETURN_REASON_CODE
,      REFUND_PRICE
,      REFUND_TYPE
,      RETURNED_REASON
,      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
,      GROWTH_RATE_NET_PROF_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
,      AVG_HIGH_CREDIT
,      HIGH_CREDIT
,      TOT_PAYMENT_EXP
,      NUM_NEGATIVE_PAYMENT
,      AVG_PAYMENT_SIZE
,      NUM_SLOW_PAYMENTS
,      FAILURE_SCORE
,      FAILURE_SCORE_OVER_CODE
,      FAILURE_SCORE_INDUSTRY_PCT
,      FAILURE_SCORE_6_MONTHS
,      GLOBAL_FAILURE_SCORE
,      DNB_SCORE
,      BUSINESS_FAILURE
,      OUT_OF_BUSINESS_FLAG
,      CUSTOMER_QUALITY_RANK
,      FORTUNE_500_RANK
,      NUM_OF_EMPLOYEES
,      LEGAL_STATUS
,      ENTITY_TYPE
,      YEAR_ESTABLISHED
,      LINE_OF_BUSINESS
,      SIC_CODE1
,      SIC_CODE2
,      MARKET_SEGMENT_NAME
,      MARKET_SEGMENT_ID
,      SITE_NAME
,      SITE_DUNS_NUMBER
,      NUM_EMPLOYEES_AT_SITE
,      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
,      BUSINESS_SCOPE
,      EMAIL_ADDRESS
,      ADDRESS1
,      ADDRESS2
,      COMPETITOR_FLAG
,      THIRD_PARTY_FLAG
,      PERSON_FIRST_NAME
,      PERSON_MIDDLE_NAME
,      PERSON_LAST_NAME
,      PERSON_NAME_SUFFIX
,      PERSON_TITLE
,      PERSON_ACADEMIC_TITLE
,      PERSON_PRE_NAME_ADJUNCT
,      CONTROL_YR
,      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
,      CORPORATION_CLASS
,      REGISTRATION_TYPE
,      INCORP_YEAR
,      PUBLIC_PRIVATE_OWNERSHIP_FLAG
,      INTERNAL_FLAG
,      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
,      PARTY_NAME
,      CITY
FROM AMS.AMS_DM_PARTY_DETAILS#;

Dependencies

[top of page]

AMS.AMS_DM_PARTY_DETAILS# references the following:

AMS: AMS_DM_PARTY_DETAILS

AMS.AMS_DM_PARTY_DETAILS# is referenced by following:

APPS: AMS_DM_PARTY_DETAILS