[Home] [Help] [Dependency Information]

TABLE: AMS.AMS_DM_GEN_STG_GT

Object Details

Temporary Table Details

AMS.AMS_DM_GEN_STG_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_DM_GEN_STG_GT_U1	NORMAL	UNIQUE		PARTY_ID

Columns

Query Text

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

SELECT PARTY_ID
,      PARTY_TYPE
,      GENDER
,      ETHNICITY
,      MARITAL_STATUS
,      PERSONAL_INCOME
,      HOH_FLAG
,      HOUSEHOLD_INCOME
,      HOUSEHOLD_SIZE
,      APARTMENT_FLAG
,      RENT_FLAG
,      DEGREE_RECEIVED
,      SCHOOL_TYPE
,      EMPLOYED_FLAG
,      YEARS_EMPLOYED
,      OCCUPATION
,      MILITARY_BRANCH
,      RESIDENCE_TYPE
,      RESIDENT_LENGTH
,      PRESENCE_OF_CHILDREN
,      COUNTRY
,      STATE
,      PROVINCE
,      COUNTY
,      ZIP_CODE
,      REFERENCE_USE_FLAG
,      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
,      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
,      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
,      PARTY_NAME
,      CITY
FROM AMS.AMS_DM_GEN_STG_GT;

Dependencies

[top of page]

AMS.AMS_DM_GEN_STG_GT does not reference any database object

AMS.AMS_DM_GEN_STG_GT is referenced by following:

APPS

AMS_DM_GEN_STG_GT