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

TABLE: DDR.DDR_E_ITEM_BSNS_UNT_ASSC

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


Error table that stores error records from DDR_I_ITEM_BSNS_UNT_ASSC


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.
RTL_ORG_CD VARCHAR2 (30)
Retail Organization Code
RTL_BSNS_UNIT_CD VARCHAR2 (30)
Retail Business unit code
MFG_SKU_ITEM_NBR VARCHAR2 (30)
Manufacturer SKU Item number
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
Query Text

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


SELECT REC_ID
,      RTL_ORG_CD
,      RTL_BSNS_UNIT_CD
,      MFG_SKU_ITEM_NBR
,      SRC_SYS_IDNT
,      SRC_SYS_DT
,      ERR_REASON
,      ACTION_FLAG
,      LOAD_ID
FROM DDR.DDR_E_ITEM_BSNS_UNT_ASSC;

Dependencies

[top of page]

DDR.DDR_E_ITEM_BSNS_UNT_ASSC does not reference any database object

DDR.DDR_E_ITEM_BSNS_UNT_ASSC is referenced by following:

SchemaAPPS
SynonymDDR_E_ITEM_BSNS_UNT_ASSC