[Home] [Help] [Dependency Information]

TABLE: AR.HZ_ORG_PROFILE_VAL_GT

Object Details

Object Name:	HZ_ORG_PROFILE_VAL_GT
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.HZ_ORG_PROFILE_VAL_GT
Subobject Name:
Status:	VALID

Temporary Table Details

AR.HZ_ORG_PROFILE_VAL_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

Columns

Query Text

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

SELECT ORGANIZATION_NAME
,      TEMP_ID
,      TEMP_PARTY_ID
,      DUNS_NUMBER_C
,      ENQUIRY_DUNS
,      CEO_NAME
,      CEO_TITLE
,      PRINCIPAL_NAME
,      PRINCIPAL_TITLE
,      LEGAL_STATUS
,      CONTROL_YR
,      EMPLOYEES_TOTAL
,      HQ_BRANCH_IND
,      BRANCH_FLAG
,      OOB_IND
,      LINE_OF_BUSINESS
,      CONG_DIST_CODE
,      SIC_CODE
,      IMPORT_IND
,      EXPORT_IND
,      LABOR_SURPLUS_IND
,      DEBARMENT_IND
,      MINORITY_OWNED_IND
,      MINORITY_OWNED_TYPE
,      WOMAN_OWNED_IND
,      DISADV_8A_IND
,      SMALL_BUS_IND
,      RENT_OWN_IND
,      DEBARMENTS_COUNT
,      DEBARMENTS_DATE
,      FAILURE_SCORE
,      FAILURE_SCORE_NATNL_PERCENTILE
,      FAILURE_SCORE_OVERRIDE_CODE
,      FAILURE_SCORE_COMMENTARY
,      GLOBAL_FAILURE_SCORE
,      DB_RATING
,      CREDIT_SCORE
,      CREDIT_SCORE_COMMENTARY
,      PAYDEX_SCORE
,      PAYDEX_THREE_MONTHS_AGO
,      PAYDEX_NORM
,      BEST_TIME_CONTACT_BEGIN
,      BEST_TIME_CONTACT_END
,      ORGANIZATION_NAME_PHONETIC
,      TAX_REFERENCE
,      GSA_INDICATOR_FLAG
,      JGZZ_FISCAL_CODE
,      ANALYSIS_FY
,      FISCAL_YEAREND_MONTH
,      CURR_FY_POTENTIAL_REVENUE
,      NEXT_FY_POTENTIAL_REVENUE
,      YEAR_ESTABLISHED
,      MISSION_STATEMENT
,      ORGANIZATION_TYPE
,      BUSINESS_SCOPE
,      CORPORATION_CLASS
,      KNOWN_AS
,      KNOWN_AS2
,      KNOWN_AS3
,      KNOWN_AS4
,      KNOWN_AS5
,      LOCAL_BUS_IDEN_TYPE
,      LOCAL_BUS_IDENTIFIER
,      PREF_FUNCTIONAL_CURRENCY
,      REGISTRATION_TYPE
,      TOTAL_EMPLOYEES_TEXT
,      TOTAL_EMPLOYEES_IND
,      TOTAL_EMP_EST_IND
,      TOTAL_EMP_MIN_IND
,      PARENT_SUB_IND
,      INCORP_YEAR
,      SIC_CODE_TYPE
,      PUBLIC_PRIVATE_OWNERSHIP_FLAG
,      INTERNAL_FLAG
,      LOCAL_ACTIVITY_CODE_TYPE
,      LOCAL_ACTIVITY_CODE
,      EMP_AT_PRIMARY_ADR
,      EMP_AT_PRIMARY_ADR_TEXT
,      EMP_AT_PRIMARY_ADR_EST_IND
,      EMP_AT_PRIMARY_ADR_MIN_IND
,      HIGH_CREDIT
,      AVG_HIGH_CREDIT
,      TOTAL_PAYMENTS
,      CREDIT_SCORE_CLASS
,      CREDIT_SCORE_NATL_PERCENTILE
,      CREDIT_SCORE_INCD_DEFAULT
,      CREDIT_SCORE_AGE
,      CREDIT_SCORE_DATE
,      CREDIT_SCORE_COMMENTARY2
,      CREDIT_SCORE_COMMENTARY3
,      CREDIT_SCORE_COMMENTARY4
,      CREDIT_SCORE_COMMENTARY5
,      CREDIT_SCORE_COMMENTARY6
,      CREDIT_SCORE_COMMENTARY7
,      CREDIT_SCORE_COMMENTARY8
,      CREDIT_SCORE_COMMENTARY9
,      CREDIT_SCORE_COMMENTARY10
,      FAILURE_SCORE_CLASS
,      FAILURE_SCORE_INCD_DEFAULT
,      FAILURE_SCORE_AGE
,      FAILURE_SCORE_DATE
,      FAILURE_SCORE_COMMENTARY2
,      FAILURE_SCORE_COMMENTARY3
,      FAILURE_SCORE_COMMENTARY4
,      FAILURE_SCORE_COMMENTARY5
,      FAILURE_SCORE_COMMENTARY6
,      FAILURE_SCORE_COMMENTARY7
,      FAILURE_SCORE_COMMENTARY8
,      FAILURE_SCORE_COMMENTARY9
,      FAILURE_SCORE_COMMENTARY10
,      MAXIMUM_CREDIT_RECOMMENDATION
,      MAXIMUM_CREDIT_CURRENCY_CODE
,      DISPLAYED_DUNS_PARTY_ID
,      CONTENT_SOURCE_TYPE
,      CONTENT_SOURCE_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CREATED_BY_MODULE
,      APPLICATION_ID
FROM AR.HZ_ORG_PROFILE_VAL_GT;

Dependencies

[top of page]

AR.HZ_ORG_PROFILE_VAL_GT does not reference any database object

AR.HZ_ORG_PROFILE_VAL_GT is referenced by following:

APPS

HZ_ORG_PROFILE_VAL_GT