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

VIEW: APPS.EGO_INTERNAL_COMPANY_V

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

View Type

A Business Intelligence System view


View EGO_INTERNAL_COMPANY_V provides all the information related to Internal Companies. Each row provides the the name, id, address, postal code and country for a given company. The unique identifier for each row is COMPANY_ID.


[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_INTERNAL_COMPANY_V;

Dependencies

[top of page]

APPS.EGO_INTERNAL_COMPANY_V references the following:

SchemaAPPS
SynonymFND_TERRITORIES_TL
SynonymHZ_CODE_ASSIGNMENTS
SynonymHZ_PARTIES

APPS.EGO_INTERNAL_COMPANY_V is not referenced by any database object