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: APPS.AMS_ORG_PROFILES_V

Object Details

Object Name:	AMS_ORG_PROFILES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_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

Name	Datatype	Length	Mandatory	Comments
AMS_ORG_PROFILE_ID	NUMBER	(15)	Yes	Primary Key
PARTY_ID	NUMBER	(15)	Yes	Party Identifier of Organization
ORGANIZATION_NAME	VARCHAR2	(360)	Yes	Organization Name
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Structure Defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield Segment column
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for Globalization Functionality
LEGAL_STATUS	VARCHAR2	(30)		Legal Structure, for example Partnership, Corporation, etc.
CONTROL_YR	NUMBER			Control year
EMPLOYEES_TOTAL	NUMBER			Total number of employees
HQ_BRANCH_IND	VARCHAR2	(30)		Status of this site. Identifies if HQ, Branch, or Single Location.
BRANCH_FLAG	VARCHAR2	(1)		Flag signifying whether this is a branch location
OOB_IND	VARCHAR2	(30)		Indicates whether this company is out of business
LINE_OF_BUSINESS	VARCHAR2	(240)		Type of business activities performed at this site
CONG_DIST_CODE	VARCHAR2	(2)		First congressional district code
IMPORT_IND	VARCHAR2	(30)		Indicates whether this company is an importer
EXPORT_IND	VARCHAR2	(30)		Indicates whether this company is an exporter
MINORITY_OWNED_IND	VARCHAR2	(30)		Indicates whether this company is owned by minorities
WOMAN_OWNED_IND	VARCHAR2	(30)		Indicates whether this company is owned by a woman
DISADV_8A_IND	VARCHAR2	(30)		Indicates whether this company is considered disadvantaged under Title 8A
SMALL_BUS_IND	VARCHAR2	(30)		Indicates whether this company is considered a small business
RENT_OWN_IND	VARCHAR2	(30)		Indicates whether this company owns or rents its place of business. Lookup of values for rent, own, lease, etc.
FAILURE_SCORE	VARCHAR2	(30)		For US the value represents the Failure Risk Class (values 1-5). For Canada the value is the Stability Score indicating risk of business closure (values 1-10). For Australia, this field carries the percentile failure score.
FAILURE_SCORE_NATL_PERCENTILE	VARCHAR2	(3)		National percentile that reflects the relative ranking of a company among all the scorable companies in the local country database.
FAILURE_SCORE_OVERRIDE_CODE	VARCHAR2	(30)		In Europe, this code indicates the reason for variance between the Dun and Bradstreet Rating and Failure Score. In the US, the code indicates the reason no score was calculated, or that the score is equal to 0.
FAILURE_SCORE_COMMENTARY	VARCHAR2	(30)		Indicator explaining failure score.
GLOBAL_FAILURE_SCORE	VARCHAR2	(5)		Global score indicating risk of business default.
DB_RATING	VARCHAR2	(5)		Dun and Bradstreet credit rating.
CREDIT_SCORE	VARCHAR2	(30)		Credit score. Indicates the risk of delinquent payments.
PAYDEX_SCORE	VARCHAR2	(3)		Paydex score for the last 12 months experiences.
PAYDEX_THREE_MONTHS_AGO	VARCHAR2	(3)		Paydex score 3 months ago.
PAYDEX_NORM	VARCHAR2	(3)		Median or average Paydex score for the industry.
BEST_TIME_CONTACT_BEGIN	DATE			Beginning of the best period of time to contact the organization.
BEST_TIME_CONTACT_END	DATE			End of the best period of time to contact the organization.
YEAR_ESTABLISHED	NUMBER	(4)		Year in which organization began doing business.
ORGANIZATION_TYPE	VARCHAR2	(30)		User defined organization types such as region, division, and department.
CORPORATION_CLASS	VARCHAR2	(60)		Taxation classification for corporation entities (for example, Chapter S in the US.)
KNOWN_AS	VARCHAR2	(240)		An alias or other name by which an organization is known.
LOCAL_BUS_IDEN_TYPE	VARCHAR2	(30)		Lookup representing main business identification number used in the country. For example, "Taxpayer ID".
LOCAL_BUS_IDENTIFIER	VARCHAR2	(60)		Primary business ID number assigned to the business by a gov't. agency, Chamber of Commerce, or Association.
PREF_FUNCTIONAL_CURRENCY	VARCHAR2	(30)		Organization's default currency code.
REGISTRATION_TYPE	VARCHAR2	(30)		Lookup for type of registration, e.g. "NonProfit".
TOTAL_EMPLOYEES_TEXT	VARCHAR2	(60)		Total number of personnel employed if can not be mapped to numeric field.
TOTAL_EMP_EST_IND	VARCHAR2	(30)		Lookup. Qualifies calculation of employees. "A" means estimated, "N" means actual.
TOTAL_EMP_MIN_IND	VARCHAR2	(30)		Lookup. Qualifies calculation of employees. "A" means minimum, "B" means maximum, and "C" is average.
PARENT_SUB_IND	VARCHAR2	(30)		Lookup. Indicates if organization is a parent or subsidiary location.
INCORP_YEAR	NUMBER	(4)		Year business was incorporated.
PUBLIC_PRIVATE_OWNERSHIP_FLAG	VARCHAR2	(1)		Y if ownership of organization is private, N if ownership is public
EMP_AT_PRIMARY_ADR	VARCHAR2	(10)		Number of employees at the referenced address
EMP_AT_PRIMARY_ADR_TEXT	VARCHAR2	(12)		Number of employees at the referenced address which cannot be mapped to a number
EMP_AT_PRIMARY_ADR_EST_IND	VARCHAR2	(30)		Qualifies calculation of employees at the primary address
EMP_AT_PRIMARY_ADR_MIN_IND	VARCHAR2	(30)		Qualifies calculation of employees at the primary address
INTERNAL_FLAG	VARCHAR2	(1)		Indicates whether the organization is internal or external. Y for Internal, N for External.
HIGH_CREDIT	NUMBER			Maximum credit of any payment experience
AVG_HIGH_CREDIT	NUMBER			Average of all high credit experiences
TOTAL_PAYMENTS	NUMBER			Total number of payment experiences
CEO_NAME	VARCHAR2	(240)
CEO_TITLE	VARCHAR2	(240)
TAX_REFERENCE	VARCHAR2	(50)
TAX_NAME	VARCHAR2	(60)
JGZZ_FISCAL_CODE	VARCHAR2	(20)
SIC_CODE	VARCHAR2	(30)
SIC_CODE_TYPE	VARCHAR2	(30)
MINORITY_OWNED_TYPE	VARCHAR2	(30)
GSA_INDICATOR_FLAG	VARCHAR2	(1)
ANALYSIS_FY	VARCHAR2	(5)
FISCAL_YEAREND_MONTH	VARCHAR2	(30)
CURR_FY_POTENTIAL_REVENUE	NUMBER
NEXT_FY_POTENTIAL_REVENUE	NUMBER
CONTENT_SOURCE_NUMBER	VARCHAR2	(30)
BUSINESS_SCOPE	VARCHAR2	(20)
LABOR_SURPLUS_IND	VARCHAR2	(30)
BUSINESS_REPORT	CLOB	(4000)

Query Text

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


SELECT AMS_ORG_PROFILE_ID
,      PARTY_ID
,      ORGANIZATION_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      LEGAL_STATUS
,      CONTROL_YR
,      EMPLOYEES_TOTAL
,      HQ_BRANCH_IND
,      BRANCH_FLAG
,      OOB_IND
,      LINE_OF_BUSINESS
,      CONG_DIST_CODE
,      IMPORT_IND
,      EXPORT_IND
,      MINORITY_OWNED_IND
,      WOMAN_OWNED_IND
,      DISADV_8A_IND
,      SMALL_BUS_IND
,      RENT_OWN_IND
,      FAILURE_SCORE
,      FAILURE_SCORE_NATL_PERCENTILE
,      FAILURE_SCORE_OVERRIDE_CODE
,      FAILURE_SCORE_COMMENTARY
,      GLOBAL_FAILURE_SCORE
,      DB_RATING
,      CREDIT_SCORE
,      PAYDEX_SCORE
,      PAYDEX_THREE_MONTHS_AGO
,      PAYDEX_NORM
,      BEST_TIME_CONTACT_BEGIN
,      BEST_TIME_CONTACT_END
,      YEAR_ESTABLISHED
,      ORGANIZATION_TYPE
,      CORPORATION_CLASS
,      KNOWN_AS
,      LOCAL_BUS_IDEN_TYPE
,      LOCAL_BUS_IDENTIFIER
,      PREF_FUNCTIONAL_CURRENCY
,      REGISTRATION_TYPE
,      TOTAL_EMPLOYEES_TEXT
,      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
,      CEO_NAME
,      CEO_TITLE
,      TAX_REFERENCE
,      TAX_NAME
,      JGZZ_FISCAL_CODE
,      SIC_CODE
,      SIC_CODE_TYPE
,      MINORITY_OWNED_TYPE
,      GSA_INDICATOR_FLAG
,      ANALYSIS_FY
,      FISCAL_YEAREND_MONTH
,      CURR_FY_POTENTIAL_REVENUE
,      NEXT_FY_POTENTIAL_REVENUE
,      CONTENT_SOURCE_NUMBER
,      BUSINESS_SCOPE
,      LABOR_SURPLUS_IND
,      BUSINESS_REPORT
FROM APPS.AMS_ORG_PROFILES_V;

Dependencies

[top of page]

APPS.AMS_ORG_PROFILES_V references the following:

APPS: HZ_ORGANIZATION_PROFILES

APPS.AMS_ORG_PROFILES_V is not referenced by any database object