[Home] [Help] [Dependency Information]

VIEW: APPS.AMS_LT_ORG_PROFILES_V

Object Details

Object Name:	AMS_LT_ORG_PROFILES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_LT_ORG_PROFILES_V
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

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

SELECT PARTY_ID
,      CEO_NAME
,      CEO_TITLE
,      LEGAL_STATUS
,      CONTROL_YR
,      EMPLOYEES_TOTAL
,      HQ_BRANCH_IND
,      BRANCH_FLAG
,      OOB_IND
,      LINE_OF_BUSINESS
,      CONG_DIST_CODE
,      SIC_CODE
,      SIC_CODE_TYPE
,      IMPORT_IND
,      EXPORT_IND
,      MINORITY_OWNED_IND
,      MINORITY_OWNED_TYPE
,      WOMAN_OWNED_IND
,      DISADV_8A_IND
,      SMALL_BUS_IND
,      RENT_OWN_IND
,      FAILURE_SCORE
,      FAILURE_SCORE_OVERRIDE_CODE
,      FAILURE_SCORE_COMMENTARY
,      GLOBAL_FAILURE_SCORE
,      DB_RATING
,      CREDIT_SCORE
,      PAYDEX_SCORE
,      PAYDEX_THREE_MONTHS_AGO
,      FISCAL_YEAREND_MONTH
,      CURR_FY_POTENTIAL_REVENUE
,      NEXT_FY_POTENTIAL_REVENUE
,      YEAR_ESTABLISHED
,      ORGANIZATION_TYPE
,      CORPORATION_CLASS
,      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
,      PUBLIC_PRIVATE_OWNERSHIP_FLAG
,      EMP_AT_PRIMARY_ADR
,      EMP_AT_PRIMARY_ADR_TEXT
,      EMP_AT_PRIMARY_ADR_EST_IND
,      EMP_AT_PRIMARY_ADR_MIN_IND
,      INTERNAL_FLAG
,      HIGH_CREDIT
,      AVG_HIGH_CREDIT
,      TOTAL_PAYMENTS
,      CONTENT_SOURCE_NUMBER
,      BUSINESS_SCOPE
,      ENQUIRY_DUNS
,      LABOR_SURPLUS_IND
,      PRINCIPAL_NAME
,      PRINCIPAL_TITLE
,      DEBARMENT_IND
,      DEBARMENTS_COUNT
,      DEBARMENTS_DATE
,      LOCAL_ACTIVITY_CODE_TYPE
,      LOCAL_ACTIVITY_CODE
,      CREDIT_SCORE_CLASS
,      CREDIT_SCORE_NATL_PERCENTILE
,      CREDIT_SCORE_INCD_DEFAULT
,      CREDIT_SCORE_AGE
,      CREDIT_SCORE_DATE
,      FAILURE_SCORE_CLASS
,      FAILURE_SCORE_INCD_DEFAULT
,      FAILURE_SCORE_AGE
,      FAILURE_SCORE_DATE
,      MAXIMUM_CREDIT_RECOMMENDATION
,      MAXIMUM_CREDIT_CURRENCY_CODE
,      DISPLAYED_DUNS_PARTY_ID
,      FAILURE_SCORE_NATNL_PERCENTILE
,      BUSINESS_REPORT
FROM APPS.AMS_LT_ORG_PROFILES_V;

Dependencies

[top of page]

APPS

HZ_ORGANIZATION_PROFILES

APPS.AMS_LT_ORG_PROFILES_V is not referenced by any database object