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

VIEW: APPS.EGO_CUSTOMER_COMPANY_V

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

View Type

A Business Intelligence System view


View EGO_COMPANIES_V contains all the data for costumer 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)
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
FROM APPS.EGO_CUSTOMER_COMPANY_V;

Dependencies

[top of page]

APPS.EGO_CUSTOMER_COMPANY_V references the following:

SchemaAPPS
SynonymFND_TERRITORIES_TL
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES

APPS.EGO_CUSTOMER_COMPANY_V is not referenced by any database object