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

TABLE: DDR.DDR_E_GEO_RGN_HCHY

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


Error table that stores error records from DDR_I_GEO_RGN_HCHY


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.
MFG_ORG_CD VARCHAR2 (30)
Manufacturer Organization code
RGN_CD VARCHAR2 (30)
Geography region code
RGN_NAME VARCHAR2 (40)
Geography region Name
RGN_DESC VARCHAR2 (240)
Geography region description
SUB_RGN_CD VARCHAR2 (30)
Geography sub-region code
SUB_RGN_NAME VARCHAR2 (40)
Geography sub-region Name
SUB_RGN_DESC VARCHAR2 (240)
Geography sub-region description
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
,      MFG_ORG_CD
,      RGN_CD
,      RGN_NAME
,      RGN_DESC
,      SUB_RGN_CD
,      SUB_RGN_NAME
,      SUB_RGN_DESC
,      SRC_SYS_IDNT
,      SRC_SYS_DT
,      ERR_REASON
,      ACTION_FLAG
,      LOAD_ID
FROM DDR.DDR_E_GEO_RGN_HCHY;

Dependencies

[top of page]

DDR.DDR_E_GEO_RGN_HCHY does not reference any database object

DDR.DDR_E_GEO_RGN_HCHY is referenced by following:

SchemaAPPS
SynonymDDR_E_GEO_RGN_HCHY