eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: DDR.DDR_E_AOH_ACCT_ATTR

Object Details

Object Name:	DDR_E_AOH_ACCT_ATTR
Object Type:	TABLE
Owner:	DDR
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_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
ACCT_CD	VARCHAR2	(30)		Unique account code
ACCT_NAME	VARCHAR2	(240)		Hierarchy description
ACCT_TYPE	VARCHAR2	(40)		Free form field, type of account
PLANNING_ACCT	VARCHAR2	(1)		Account used for planning purpose. Y for yes, N for no
PRI_CONTACT_NAME	VARCHAR2	(240)		Contact name
PRI_CONTACT_PHONE	VARCHAR2	(30)		Contact Phone
ACCT_ADDR_L1	VARCHAR2	(240)		Account address
ACCT_CITY_CD	VARCHAR2	(30)		Account city location
ACCT_STATE_CD	VARCHAR2	(30)		Account state
ACCT_POSTAL_CD	VARCHAR2	(30)		Account location postal code
ACCT_COUNTRY_CD	VARCHAR2	(30)		Account country
PARENT_ACCT_CD	VARCHAR2	(30)		Parent account code
ULT_PRNT_ACCT_CD	VARCHAR2	(30)		Top most parent account code
ATTRIBUTE1	VARCHAR2	(240)		User defined attribute 1
ATTRIBUTE2	VARCHAR2	(240)		User defined attribute 2
ATTRIBUTE3	VARCHAR2	(240)		User defined attribute 3
ATTRIBUTE4	VARCHAR2	(240)		User defined attribute 4
ATTRIBUTE5	VARCHAR2	(240)		User defined attribute 5
ATTRIBUTE6	VARCHAR2	(240)		User defined attribute 6
ATTRIBUTE7	VARCHAR2	(240)		User defined attribute 7
ATTRIBUTE8	VARCHAR2	(240)		User defined attribute 8
ATTRIBUTE9	VARCHAR2	(240)		User defined attribute 9
ATTRIBUTE10	VARCHAR2	(240)		User defined attribute 10
ATTRIBUTE11	NUMBER			User defined attribute 11
ATTRIBUTE12	NUMBER			User defined attribute 12
ATTRIBUTE13	NUMBER			User defined attribute 13
ATTRIBUTE14	NUMBER			User defined attribute 14
ATTRIBUTE15	NUMBER			User defined attribute 15
ATTRIBUTE16	NUMBER			User defined attribute 16
ATTRIBUTE17	NUMBER			User defined attribute 17
ATTRIBUTE18	NUMBER			User defined attribute 18
ATTRIBUTE19	NUMBER			User defined attribute 19
ATTRIBUTE20	NUMBER			User defined attribute 20
SRC_SYS_IDNT	VARCHAR2	(40)	Yes	Source system id
SRC_SYS_DT	DATE		Yes	Source system date
ERR_REASON	VARCHAR2	(500)	Yes	cord error reason
ACTION_FLAG	VARCHAR2	(1)	Yes	Error correction flag
LOAD_ID	NUMBER		Yes	Load number
SRC_IDNT_FLAG	VARCHAR2	(1)		Flag indicating the origin of the error record, it can come from Interface/Stage, possible values can be 'I/S'
AO_HCHY_ID	NUMBER			Indentifier for the Alternate Org Hierarchy

Query Text

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


SELECT REC_ID
,      AO_HCHY_CD
,      ACCT_CD
,      ACCT_NAME
,      ACCT_TYPE
,      PLANNING_ACCT
,      PRI_CONTACT_NAME
,      PRI_CONTACT_PHONE
,      ACCT_ADDR_L1
,      ACCT_CITY_CD
,      ACCT_STATE_CD
,      ACCT_POSTAL_CD
,      ACCT_COUNTRY_CD
,      PARENT_ACCT_CD
,      ULT_PRNT_ACCT_CD
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      SRC_SYS_IDNT
,      SRC_SYS_DT
,      ERR_REASON
,      ACTION_FLAG
,      LOAD_ID
,      SRC_IDNT_FLAG
,      AO_HCHY_ID
FROM DDR.DDR_E_AOH_ACCT_ATTR;

Dependencies

[top of page]

DDR.DDR_E_AOH_ACCT_ATTR does not reference any database object

DDR.DDR_E_AOH_ACCT_ATTR is referenced by following:

DDR: DDR_E_AOH_ACCT_ATTR#