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

VIEW: APPS.OKX_PARTY_SITES_V

Object Details
Object Name: OKX_PARTY_SITES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_PARTY_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 Party site use identifier
ID2 CHAR (1)
(Multi-part) Primary Key
LOCATION_ID NUMBER (15) Yes Location identifier and foreign key to HZ_LOCATIONS.
PARTY_SITE_NUMBER VARCHAR2 (30) Yes Party site number
PARTY_ID NUMBER (15) Yes Party identifier and foreign key to HZ_PARTIES.
NAME VARCHAR2 (240)
A user defined name for the site
STATUS VARCHAR2 (1) Yes Party site status flag
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)
Description of the site use
DESCRIPTION VARCHAR2 (80)
Formatted address, country specific
IDENTIFYING_ADDRESS_FLAG VARCHAR2 (1) Yes Y or N indicates whether this is the identifying address for the party.
ADDRESSEE VARCHAR2 (360)
addressee information
Query Text

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


SELECT ID1
,      ID2
,      LOCATION_ID
,      PARTY_SITE_NUMBER
,      PARTY_ID
,      NAME
,      STATUS
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      LOCATION_DESCRIPTION
,      DESCRIPTION
,      IDENTIFYING_ADDRESS_FLAG
,      ADDRESSEE
FROM APPS.OKX_PARTY_SITES_V;

Dependencies

[top of page]

APPS.OKX_PARTY_SITES_V references the following:

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

SchemaAPPS
Package BodyOKL_OPEN_INTERFACE_PVT - show dependent code
Package BodyOKS_AUTH_UTIL_PVT - show dependent code
Package BodyOKS_ENTITLEMENTS_PVT - show dependent code
Package BodyOKS_ENTITLEMENTS_WEB - show dependent code
Package BodyOKS_ENT_UTIL_PVT - show dependent code
Package BodyOKS_MASS_UPD_PVT - show dependent code