[Home] [Help] [Dependency Information]
Object Name: | OKC_XPRT_DEVIATIONS_T |
---|---|
Object Type: | TABLE |
Owner: | OKC |
FND Design Data: | OKC.OKC_XPRT_DEVIATIONS_T |
Subobject Name: | |
Status: | VALID |
Temporary Table to store Contract Standard Deviation details (expert rule conditions with document values) data
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKC_XPRT_DEVIATIONS_T_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
RUN_ID
PROCEDURE_NAME |
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. |
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;
OKC.OKC_XPRT_DEVIATIONS_T does not reference any database object
OKC.OKC_XPRT_DEVIATIONS_T is referenced by following:
|
|
|