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


VIEW: APPS.PO_VENDOR_SITES_ALL1_DFV

Object Details
Object Name: PO_VENDOR_SITES_ALL1_DFV
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CONTEXT_VALUE VARCHAR2 (30)
LINE_1 VARCHAR2 (240)
LINE_2 VARCHAR2 (240)
LINE_3 VARCHAR2 (240)
POSTAL_CODE VARCHAR2 (20)
TOWN VARCHAR2 (60)
PROVINCE VARCHAR2 (60)
CITY VARCHAR2 (60)
ADDRESS_LINE_1 VARCHAR2 (240)
ADDRESS_LINE_2 VARCHAR2 (240)
ADDRESS_LINE_3 VARCHAR2 (240)
ALTERNATE_ADDRESS VARCHAR2 (560)
ADDRESS_1 VARCHAR2 (240)
ADDRESS_2 VARCHAR2 (240)
ADDRESS_3 VARCHAR2 (240)
COUNTRY_CODE VARCHAR2 (60)
STATE VARCHAR2 (60)
STATE_CODE VARCHAR2 (60)
TOWN_CITY VARCHAR2 (60)
COUNTY VARCHAR2 (60)
CONCATENATED_SEGMENTS VARCHAR2 (1457)
Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      LINE_1
,      LINE_2
,      LINE_3
,      POSTAL_CODE
,      TOWN
,      PROVINCE
,      CITY
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      ALTERNATE_ADDRESS
,      ADDRESS_1
,      ADDRESS_2
,      ADDRESS_3
,      COUNTRY_CODE
,      STATE
,      STATE_CODE
,      TOWN_CITY
,      COUNTY
,      CONCATENATED_SEGMENTS
FROM APPS.PO_VENDOR_SITES_ALL1_DFV;

Dependencies

[top of page]

APPS.PO_VENDOR_SITES_ALL1_DFV references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewPO_VENDOR_SITES_ALL

APPS.PO_VENDOR_SITES_ALL1_DFV is not referenced by any database object