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

VIEW: APPS.OKX_CUST_SITES_V

Object Details
Object Name: OKX_CUST_SITES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_CUST_SITES_V
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
ID1 NUMBER (15) Yes Site use identifier
ID2 CHAR (1)
(Multi-part) Primary Key
CUST_ACCT_SITE_ID NUMBER (15) Yes Customer Site identifier
CUST_ACCOUNT_ID NUMBER (15) Yes Customer Account identifier. FK to HZ_CUST_ACCOUNTS_ALL
PARTY_SITE_ID NUMBER (15) Yes Party Site identifier. FK to HZ_PARTY_SITES
PARTY_ID NUMBER (15) Yes Party identifier and foreign key to HZ_PARTIES.
PARTY_SITE_NAME VARCHAR2 (240)
A user defined name for the site
STATUS VARCHAR2 (1) Yes Status
LOCATION_ID NUMBER (15) Yes Location Identifier
NAME VARCHAR2 (240)
Site use identifier
COUNTRY VARCHAR2 (60) Yes FND_TERRITORY.TERRITORY_CODE
ADDRESS1 VARCHAR2 (240) Yes First line for address
ADDRESS2 VARCHAR2 (240)
Second line for address
ADDRESS3 VARCHAR2 (240)
Third line for address
ADDRESS4 VARCHAR2 (240)
Fourth line for address
CITY VARCHAR2 (60)
City
POSTAL_CODE VARCHAR2 (60)
Postal code
STATE VARCHAR2 (60)
State
PROVINCE VARCHAR2 (60)
Province
COUNTY VARCHAR2 (60)
County
LOCATION_DESCRIPTION VARCHAR2 (2000)
An extensive description of the location
DESCRIPTION VARCHAR2 (4000)
Formatted address, country specific
ORG_ID NUMBER (15)
Operating Unit Identifier
PRIMARY_UOM_CODE VARCHAR2 (0)
Used for lines entry, list for UOM.
ADDRESSEE VARCHAR2 (360)
addressee information
Query Text

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


SELECT ID1
,      ID2
,      CUST_ACCT_SITE_ID
,      CUST_ACCOUNT_ID
,      PARTY_SITE_ID
,      PARTY_ID
,      PARTY_SITE_NAME
,      STATUS
,      LOCATION_ID
,      NAME
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      LOCATION_DESCRIPTION
,      DESCRIPTION
,      ORG_ID
,      PRIMARY_UOM_CODE
,      ADDRESSEE
FROM APPS.OKX_CUST_SITES_V;

Dependencies

[top of page]

APPS.OKX_CUST_SITES_V references the following:

SchemaAPPS
PL/SQL PackageARP_ADDR_LABEL_PKG - show dependent code
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_LOCATIONS
SynonymHZ_PARTY_SITES
APPS.OKX_CUST_SITES_V is referenced by following:

SchemaAPPS
Package BodyOKC_PRICE_PUB - show dependent code
Package BodyOKL_REPORT_PVT - show dependent code
Package BodyOKS_AUTH_UTIL_PVT - show dependent code
PL/SQL PackageOKS_AUTH_UTIL_PVT - show dependent code
Package BodyOKS_CONTRACTS_PUB - show dependent code
Package BodyOKS_EXTWARPRGM_PVT - show dependent code
Package BodyOKS_SETUP_UTIL_PUB - show dependent code