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

VIEW: APPS.EGO_COMPANIES_V

Object Details
Object Name: EGO_COMPANIES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEGO.EGO_COMPANIES_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


View EGO_COMPANIES_V contains all the data for Companies such as company name, id, type, addresses, postal codes, and location.


[View Source]

Columns
Name Datatype Length Mandatory Comments
COMPANY_ID NUMBER (15) Yes Party identifier (From HZ_PARTIES)
COMPANY_NAME VARCHAR2 (360) Yes Name of the Company(party)
ADDRESS1 VARCHAR2 (240)
First line of the Identifying address
ADDRESS2 VARCHAR2 (240)
Second line of the Identifying address
ADDRESS3 VARCHAR2 (240)
Third line of the Identifying address
ADDRESS4 VARCHAR2 (240)
Fourth line of the Identifying address
CITY VARCHAR2 (60)
City of the Identifying address
COUNTY VARCHAR2 (60)
County of the Identifying address
PROVINCE VARCHAR2 (60)
Province of the Identifying address
STATE VARCHAR2 (60)
State of the Identifying address
POSTAL_CODE VARCHAR2 (60)
Postal Code of the Identifying address
COUNTRY VARCHAR2 (80)
Country for the Identifying address.(Taken from fnd_territories_tl)
COMPANY_TYPE VARCHAR2 (80)
Type of the company
Query Text

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


SELECT COMPANY_ID
,      COMPANY_NAME
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      COUNTY
,      PROVINCE
,      STATE
,      POSTAL_CODE
,      COUNTRY
,      COMPANY_TYPE
FROM APPS.EGO_COMPANIES_V;

Dependencies

[top of page]

APPS.EGO_COMPANIES_V references the following:

SchemaAPPS
SynonymAP_SUPPLIERS
SynonymFND_LOOKUP_VALUES
SynonymFND_TERRITORIES_TL
SynonymHZ_CODE_ASSIGNMENTS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
APPS.EGO_COMPANIES_V is referenced by following:

SchemaAPPS
Package BodyEGO_CHANGE_PEOPLE_IMPORT_PKG - show dependent code
Package BodyEGO_ITEM_PEOPLE_IMPORT_PKG - show dependent code