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

VIEW: APPS.OKL_INS_PARTYSITES_V

Object Details
Object Name: OKL_INS_PARTYSITES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_INS_PARTYSITES_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
PARTY_ID NUMBER (15) Yes Identifier for the party.
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
COUNTRY VARCHAR2 (60) Yes Country code from the TERRITORY_CODE column in the FND_TERRITORY table
PROVINCE VARCHAR2 (60)
Province
COUNTY VARCHAR2 (60)
County
ADDRESS VARCHAR2 (1329)
Complete address concatenated togther
SITE_ID NUMBER (15) Yes Party site identifier
CATEGORY_CODE VARCHAR2 (30)
User-definable category. Lookup type is CUSTOMER_CATEGORY
Query Text

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


SELECT PARTY_ID
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      STATE
,      COUNTRY
,      PROVINCE
,      COUNTY
,      ADDRESS
,      SITE_ID
,      CATEGORY_CODE
FROM APPS.OKL_INS_PARTYSITES_V;

Dependencies

[top of page]

APPS.OKL_INS_PARTYSITES_V references the following:

SchemaAPPS
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
APPS.OKL_INS_PARTYSITES_V is referenced by following:

SchemaAPPS
Package BodyOKL_IPY_PVT - show dependent code
Package BodyOKL_SSC_WF - show dependent code