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

VIEW: APPS.OKE_CUST_SITE_USES_V

Object Details
Object Name: OKE_CUST_SITE_USES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKE.OKE_CUST_SITE_USES_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID1 NUMBER (15) Yes Customer site usage unique identifer
ID2 CHAR (1)
Not currently used
SITE_USE_ID NUMBER (15) Yes Customer site usage unique identifer
NAME VARCHAR2 (83)
User-defined name for the customer site usage
CUST_ACCT_SITE_ID NUMBER (15) Yes Customer site unique identifier
CUST_ACCOUNT_ID NUMBER (15) Yes Customer account unique identifier
PARTY_SITE_ID NUMBER (15) Yes Party site unique identifier
PARTY_ID NUMBER (15) Yes Party unique identifier
PARTY_NAME VARCHAR2 (360) Yes Party name
PARTY_SITE_NAME VARCHAR2 (240)
Party site name
SITE_USE_CODE VARCHAR2 (30) Yes Business purpose
B_STATUS VARCHAR2 (1)
Site usage status
STATUS VARCHAR2 (1) Yes Site usage status
LOCATION_ID NUMBER (15) Yes Location unique identifier
LOCATION VARCHAR2 (40) Yes Description of location
COUNTRY VARCHAR2 (60) Yes Country
ADDRESS1 VARCHAR2 (240) Yes First line of address
ADDRESS2 VARCHAR2 (240)
Second line of address
ADDRESS3 VARCHAR2 (240)
Third line of address
ADDRESS4 VARCHAR2 (240)
Forth line of address
CITY VARCHAR2 (60)
City
POSTAL_CODE VARCHAR2 (60)
ZIP or postal code
STATE VARCHAR2 (60)
State
PROVINCE VARCHAR2 (60)
Province
COUNTY VARCHAR2 (60)
County
LOCATION_DESCRIPTION VARCHAR2 (2000)
Description of location
DESCRIPTION VARCHAR2 (80)
Description of customer site
ORG_ID NUMBER (15)
Operating unit unique identifier
PRIMARY_UOM_CODE VARCHAR2 (0)
Not currently used
Query Text

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


SELECT ID1
,      ID2
,      SITE_USE_ID
,      NAME
,      CUST_ACCT_SITE_ID
,      CUST_ACCOUNT_ID
,      PARTY_SITE_ID
,      PARTY_ID
,      PARTY_NAME
,      PARTY_SITE_NAME
,      SITE_USE_CODE
,      B_STATUS
,      STATUS
,      LOCATION_ID
,      LOCATION
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      LOCATION_DESCRIPTION
,      DESCRIPTION
,      ORG_ID
,      PRIMARY_UOM_CODE
FROM APPS.OKE_CUST_SITE_USES_V;

Dependencies

[top of page]

APPS.OKE_CUST_SITE_USES_V references the following:

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

SchemaAPPS
Package BodyOKE_AMG_GRP - show dependent code
Package BodyOKE_CONTRACT_PUB - show dependent code
Package BodyOKE_DEFAULTING_PKG - show dependent code
Package BodyOKE_DELIVERABLE_ACTIONS_PKG - show dependent code
Package BodyOKE_DELIVERABLE_PVT - show dependent code
Package BodyOKE_DTS_ACTION_PKG - show dependent code
Package BodyOKE_DTS_INTEGRATION_PKG - show dependent code
Package BodyOKE_DTS_WORKFLOW - show dependent code
Package BodyOKE_DTS_WSH_PKG - show dependent code
Package BodyOKE_FORM_DD250 - show dependent code
Package BodyOKE_VERSION_COMPARISON_PKG - show dependent code