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

TABLE: DDR.DDR_E_AOH_ATTR

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

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
REC_ID NUMBER
Yes Unique record ID
AO_HCHY_CD VARCHAR2 (30)
Unique hierarchy code
AO_HCHY_NAME VARCHAR2 (30)
Hierarchy name
AO_HCHY_DESC VARCHAR2 (240)
Hierarchy description
SRC_SYS_IDNT VARCHAR2 (40) Yes Source System Identifier
SRC_SYS_DT DATE
Yes Source System Date
ERR_REASON VARCHAR2 (500) Yes Record error reason
ACTION_FLAG VARCHAR2 (1) Yes Error correction flag
LOAD_ID NUMBER
Yes Load number
Query Text

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


SELECT REC_ID
,      AO_HCHY_CD
,      AO_HCHY_NAME
,      AO_HCHY_DESC
,      SRC_SYS_IDNT
,      SRC_SYS_DT
,      ERR_REASON
,      ACTION_FLAG
,      LOAD_ID
FROM DDR.DDR_E_AOH_ATTR;

Dependencies

[top of page]

DDR.DDR_E_AOH_ATTR does not reference any database object

DDR.DDR_E_AOH_ATTR is referenced by following:

SchemaDDR
ViewDDR_E_AOH_ATTR#