Skip to content

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

TABLE: DDR.DDR_E_ITEM_CLSTR

Object Details
Object Name: DDR_E_ITEM_CLSTR
Object Type: TABLE
Owner: DDR
Subobject Name:
Status: VALID


Error table that stores error records from DDR_I_ITEM_CLSTR


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
REC_ID NUMBER
Yes Record ID, uniquely identify each records.
ITEM_CLSTR_CD VARCHAR2 (30)
Item Cluster Code
ITEM_CLSTR_TYP VARCHAR2 (30)
LVL_CD VARCHAR2 (30)
PROD_ENT_CD VARCHAR2 (30)
SRC_SYS_IDNT VARCHAR2 (40) Yes Source file name or system that provided the data. It can be used to cross-reference the data with the source system, mainly for auditing purpose
SRC_SYS_DT DATE
Yes The date that the data was created. It can be used to cross-reference the data with the source system, mainly for auditing purpose
ERR_REASON VARCHAR2 (500) Yes Descriptive reason why the record failed validation and came in error table
ACTION_FLAG VARCHAR2 (1) Yes Flag indicating the status of error record and what needs to be done on it, possible values can be 'N/Y/D', N - Not corrected; Y- Corrected, ready for processing; D- to be deleted
LOAD_ID NUMBER
Yes Load ID is required for identifying each load records
MFG_SKU_ITEM_NBR VARCHAR2 (30)
Manufacturer sku item number
PROCESS_ACTION VARCHAR2 (1)
Query Text

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


SELECT REC_ID
,      ITEM_CLSTR_CD
,      ITEM_CLSTR_TYP
,      LVL_CD
,      PROD_ENT_CD
,      SRC_SYS_IDNT
,      SRC_SYS_DT
,      ERR_REASON
,      ACTION_FLAG
,      LOAD_ID
,      MFG_SKU_ITEM_NBR
,      PROCESS_ACTION
FROM DDR.DDR_E_ITEM_CLSTR;

Dependencies

[top of page]

DDR.DDR_E_ITEM_CLSTR does not reference any database object

DDR.DDR_E_ITEM_CLSTR is referenced by following:

SchemaDDR
ViewDDR_E_ITEM_CLSTR#