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

TABLE: OKC.OKC_DELIVERABLE_TYPES_B

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


Stores the definition of all the deliverable types. Following are the three deliverable types supported after 11.5.10.
Contractual
Internal Purchasing
Sourcing
Internal


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKC_DELIVERABLE_TYPES_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnDELIVERABLE_TYPE_CODE
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
DELIVERABLE_TYPE_CODE VARCHAR2 (30) Yes Code to uniquely identify the deliverable type.
INTERNAL_FLAG VARCHAR2 (1) Yes Flag to indicate if the deliverable type is INTERNAL or not. Valid values are Y and N. A deliverable that is a not internal is deemed to be Contractual in nature and is printed as part of the contract and fullfiled as part of the obligations of either party on the contract.
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
OBJECT_VERSION_NUMBER NUMBER (9)
Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT DELIVERABLE_TYPE_CODE
,      INTERNAL_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      ZD_EDITION_NAME
FROM OKC.OKC_DELIVERABLE_TYPES_B;

Dependencies

[top of page]

OKC.OKC_DELIVERABLE_TYPES_B does not reference any database object

OKC.OKC_DELIVERABLE_TYPES_B is referenced by following:

SchemaOKC
ViewOKC_DELIVERABLE_TYPES_B#