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

VIEW: APPS.CSI_INST_CURRENT_LOCATION_V

Object Details
Object Name: CSI_INST_CURRENT_LOCATION_V
Object Type: VIEW
Owner: APPS
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
INSTANCE_ID NUMBER

Instance Id
PARTY_NAME VARCHAR2 (360)
Party Name
PARTY_NUMBER VARCHAR2 (30)
Party Number
ADDRESS1 VARCHAR2 (240)
Address1
ADDRESS2 VARCHAR2 (240)
Address2
ADDRESS3 VARCHAR2 (4000)
Address3
ADDRESS4 VARCHAR2 (240)
Address4
CITY VARCHAR2 (60)
City
STATE VARCHAR2 (120)
State
POSTAL_CODE VARCHAR2 (60)
Postal Code
COUNTRY VARCHAR2 (60)
Country
PARTY_SITE_NUMBER VARCHAR2 (30)
Party Site Number
COMPLETE_ADDRESS VARCHAR2 (4000)
Complete Address
Query Text

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


SELECT INSTANCE_ID
,      PARTY_NAME
,      PARTY_NUMBER
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      STATE
,      POSTAL_CODE
,      COUNTRY
,      PARTY_SITE_NUMBER
,      COMPLETE_ADDRESS
FROM APPS.CSI_INST_CURRENT_LOCATION_V;

Dependencies

[top of page]

APPS.CSI_INST_CURRENT_LOCATION_V references the following:

SchemaAPPS
ViewCSI_HZPTY_ADDRESSES_V
SynonymCSI_ITEM_INSTANCES
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
SynonymHZ_LOCATIONS
PL/SQL PackageINV_PROJECT - show dependent code
SynonymMTL_ITEM_LOCATIONS
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS
ViewPO_VENDOR_SITES_ALL
SynonymWIP_ENTITIES

APPS.CSI_INST_CURRENT_LOCATION_V is not referenced by any database object