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

TABLE: OKC.OKC_USER_BINS

Object Details
Object Name: OKC_USER_BINS
Object Type: TABLE
Owner: OKC
FND Design Data: TableOKC.OKC_USER_BINS
Subobject Name:
Status: VALID


A denormalized entity used to maintian various lists of contracts for user portals, such as the bookmark list and the recent documents list. The contract number, modifier, and short description are kept here so that they still may be displayed to the user even if that contract is no longer accessible to the user.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKC_USER_BINS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID
OKC_USER_BINS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCREATED_BY
ColumnBIN_TYPE
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes System generated Unique Identifier.
CONTRACT_ID NUMBER
Yes Foreign Key to OKC_K_HEADERS_B.
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract Number.
BIN_TYPE VARCHAR2 (12) Yes The Type of Bin: Recent or Bookmark .
CONTRACT_TYPE VARCHAR2 (12) Yes Contract Type.
PROGRAM_NAME VARCHAR2 (40) Yes Program to run for this contract.
CREATED_BY NUMBER (15) Yes Standard Who column.
CREATION_DATE DATE
Yes Standard Who column.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Unique internal contract number.
SHORT_DESCRIPTION VARCHAR2 (600)
User entered free format abbreviated text description.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
Query Text

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


SELECT ID
,      CONTRACT_ID
,      CONTRACT_NUMBER
,      BIN_TYPE
,      CONTRACT_TYPE
,      PROGRAM_NAME
,      CREATED_BY
,      CREATION_DATE
,      CONTRACT_NUMBER_MODIFIER
,      SHORT_DESCRIPTION
,      SECURITY_GROUP_ID
FROM OKC.OKC_USER_BINS;

Dependencies

[top of page]

OKC.OKC_USER_BINS does not reference any database object

OKC.OKC_USER_BINS is referenced by following:

SchemaOKC
ViewOKC_USER_BINS#