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

VIEW: APPS.OKX_STATES_V

Object Details
Object Name: OKX_STATES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_STATES_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
Yes Primary key column. Unique identifier for location
ID2 CHAR (1)
Primary key column
NAME VARCHAR2 (240) Yes Location name
DESCRIPTION VARCHAR2 (4000)
Not used
LOCATION_AREA_ID NUMBER
Yes Unique identifier for location area
ORIG_SYSTEM_REF NUMBER

Reference code of the application which created this geographic area
ORIG_SYSTEM_ID VARCHAR2 (30)
Reference id of the geographic area in the originating system
LOCATION_TYPE_CODE VARCHAR2 (30) Yes Foreign key to JTF_LOC_TYPES_B
LOCATION_AREA_CODE VARCHAR2 (30)
The short name for the location area
PARENT_LOCATION_AREA_ID NUMBER

Identifier for the parent location area
SECURITY_GROUP_ID NUMBER

Identifier for security group
START_DATE_ACTIVE DATE
Yes Effective from date
END_DATE_ACTIVE DATE

Effective to date
STATUS VARCHAR2 (1)
Indicates whether record is active or inactive
PRIMARY_UOM_CODE VARCHAR2 (0)
Primary unit of measure code
Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      LOCATION_AREA_ID
,      ORIG_SYSTEM_REF
,      ORIG_SYSTEM_ID
,      LOCATION_TYPE_CODE
,      LOCATION_AREA_CODE
,      PARENT_LOCATION_AREA_ID
,      SECURITY_GROUP_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      PRIMARY_UOM_CODE
FROM APPS.OKX_STATES_V;

Dependencies

[top of page]

APPS.OKX_STATES_V references the following:

SchemaAPPS
SynonymJTF_LOC_AREAS_B
SynonymJTF_LOC_AREAS_TL
APPS.OKX_STATES_V is referenced by following:

SchemaAPPS
ViewOKL_BPD_LATE_POLICIES_UV