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

TABLE: OKC.OKC_DEL_STATUS_COMBXNS

Object Details
Object Name: OKC_DEL_STATUS_COMBXNS
Object Type: TABLE
Owner: OKC
FND Design Data: TableOKC.OKC_DEL_STATUS_COMBXNS
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.

Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKC_DEL_STATUS_COMBXNS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnSTATUS_CHANGED_BY
ColumnCURRENT_STATUS_CODE
ColumnALLOWABLE_STATUS_CODE
Columns
Name Datatype Length Mandatory Comments
CURRENT_STATUS_CODE VARCHAR2 (30) Yes Code to indicate the current status of a Deliverable. Points to fnd LOOKUP_TYPE `OKC_DELIVERABLE_STATUS`.
ALLOWABLE_STATUS_CODE VARCHAR2 (30) Yes Code to indicate the possible statuses that a Deliverable can change to from current status. Points to fnd lookup type OKC_DELIVERABLE_STATUS.
STATUS_CHANGED_BY VARCHAR2 (240) Yes Internal or External party user that changed the Deliverable status
CREATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
Query Text

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


SELECT CURRENT_STATUS_CODE
,      ALLOWABLE_STATUS_CODE
,      STATUS_CHANGED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM OKC.OKC_DEL_STATUS_COMBXNS;

Dependencies

[top of page]

OKC.OKC_DEL_STATUS_COMBXNS does not reference any database object

OKC.OKC_DEL_STATUS_COMBXNS is referenced by following:

SchemaAPPS
SynonymOKC_DEL_STATUS_COMBXNS