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

TABLE: OKC.OKC_XPRT_DEVIATIONS_T

Object Details
Object Name: OKC_XPRT_DEVIATIONS_T
Object Type: TABLE
Owner: OKC
Subobject Name:
Status: VALID


Temporary Table to store Contract Standard Deviation details (expert rule conditions with document values) data


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
RUN_ID NUMBER
Yes Oracle Configurator run id
LINE_NUMBER VARCHAR2 (250)
Line Number from the item line in the document for which the deviation is reported
VARIABLE_CODE VARCHAR2 (40) Yes Variable Code that caused the deviation
VARIABLE_VALUE VARCHAR2 (2000)
Value of the variable that results in the deviation
ITEM_ID NUMBER

Item Id that caused policy deviation
ORG_ID NUMBER

Organization Id
CREATION_DATE DATE

Date of creation of the deviation
PROCEDURE_NAME VARCHAR2 (200)
This column stores the PACKAGE.PROCEDURENAME to source user defined variables. This is not applicable / not used in base R12 and prior releases.
Query Text

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


SELECT RUN_ID
,      LINE_NUMBER
,      VARIABLE_CODE
,      VARIABLE_VALUE
,      ITEM_ID
,      ORG_ID
,      CREATION_DATE
,      PROCEDURE_NAME
FROM OKC.OKC_XPRT_DEVIATIONS_T;

Dependencies

[top of page]

OKC.OKC_XPRT_DEVIATIONS_T does not reference any database object

OKC.OKC_XPRT_DEVIATIONS_T is referenced by following:

SchemaAPPS
SynonymOKC_XPRT_DEVIATIONS_T