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_R_PROD_ENT_EXTN

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
DDR_R_PROD_ENT_EXTN_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROD_ENT_ID

Columns

Name	Datatype	Length	Mandatory
MFG_ORG_CD	VARCHAR2	(30)	Yes
PROD_ENT_ID	NUMBER		Yes
ORG_CD	VARCHAR2	(30)	Yes
PROD_ENT_CD	VARCHAR2	(30)	Yes
ATTR_NAME_1	VARCHAR2	(40)
ATTR_VAL_1	VARCHAR2	(40)
ATTR_NAME_2	VARCHAR2	(40)
ATTR_VAL_2	VARCHAR2	(40)
ATTR_NAME_3	VARCHAR2	(40)
ATTR_VAL_3	VARCHAR2	(40)
ATTR_NAME_4	VARCHAR2	(40)
ATTR_VAL_4	VARCHAR2	(40)
ATTR_NAME_5	VARCHAR2	(40)
ATTR_VAL_5	VARCHAR2	(40)
ATTR_NAME_6	VARCHAR2	(40)
ATTR_VAL_6	VARCHAR2	(40)
ATTR_NAME_7	VARCHAR2	(40)
ATTR_VAL_7	VARCHAR2	(40)
ATTR_NAME_8	VARCHAR2	(40)
ATTR_VAL_8	VARCHAR2	(40)
ATTR_NAME_9	VARCHAR2	(40)
ATTR_VAL_9	VARCHAR2	(40)
ATTR_NAME_10	VARCHAR2	(40)
ATTR_VAL_10	VARCHAR2	(40)
ATTR_NAME_11	VARCHAR2	(40)
ATTR_VAL_11	VARCHAR2	(40)
ATTR_NAME_12	VARCHAR2	(40)
ATTR_VAL_12	VARCHAR2	(40)
ATTR_NAME_13	VARCHAR2	(40)
ATTR_VAL_13	VARCHAR2	(40)
ATTR_NAME_14	VARCHAR2	(40)
ATTR_VAL_14	VARCHAR2	(40)
ATTR_NAME_15	VARCHAR2	(40)
ATTR_VAL_15	VARCHAR2	(40)
ATTR_NAME_16	VARCHAR2	(40)
ATTR_VAL_16	VARCHAR2	(40)
ATTR_NAME_17	VARCHAR2	(40)
ATTR_VAL_17	VARCHAR2	(40)
ATTR_NAME_18	VARCHAR2	(40)
ATTR_VAL_18	VARCHAR2	(40)
ATTR_NAME_19	VARCHAR2	(40)
ATTR_VAL_19	VARCHAR2	(40)
ATTR_NAME_20	VARCHAR2	(40)
ATTR_VAL_20	VARCHAR2	(40)
EFF_FROM_DT	DATE		Yes
EFF_TO_DT	DATE
SRC_SYS_IDNT	VARCHAR2	(40)	Yes
SRC_SYS_DT	DATE		Yes
CRTD_BY_DSR	VARCHAR2	(30)	Yes
LAST_UPDT_BY_DSR	VARCHAR2	(30)	Yes
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes

Query Text

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


SELECT MFG_ORG_CD
,      PROD_ENT_ID
,      ORG_CD
,      PROD_ENT_CD
,      ATTR_NAME_1
,      ATTR_VAL_1
,      ATTR_NAME_2
,      ATTR_VAL_2
,      ATTR_NAME_3
,      ATTR_VAL_3
,      ATTR_NAME_4
,      ATTR_VAL_4
,      ATTR_NAME_5
,      ATTR_VAL_5
,      ATTR_NAME_6
,      ATTR_VAL_6
,      ATTR_NAME_7
,      ATTR_VAL_7
,      ATTR_NAME_8
,      ATTR_VAL_8
,      ATTR_NAME_9
,      ATTR_VAL_9
,      ATTR_NAME_10
,      ATTR_VAL_10
,      ATTR_NAME_11
,      ATTR_VAL_11
,      ATTR_NAME_12
,      ATTR_VAL_12
,      ATTR_NAME_13
,      ATTR_VAL_13
,      ATTR_NAME_14
,      ATTR_VAL_14
,      ATTR_NAME_15
,      ATTR_VAL_15
,      ATTR_NAME_16
,      ATTR_VAL_16
,      ATTR_NAME_17
,      ATTR_VAL_17
,      ATTR_NAME_18
,      ATTR_VAL_18
,      ATTR_NAME_19
,      ATTR_VAL_19
,      ATTR_NAME_20
,      ATTR_VAL_20
,      EFF_FROM_DT
,      EFF_TO_DT
,      SRC_SYS_IDNT
,      SRC_SYS_DT
,      CRTD_BY_DSR
,      LAST_UPDT_BY_DSR
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM DDR.DDR_R_PROD_ENT_EXTN;

Dependencies

[top of page]

DDR.DDR_R_PROD_ENT_EXTN does not reference any database object

DDR.DDR_R_PROD_ENT_EXTN is referenced by following:

APPS: DDR_R_PROD_ENT_EXTN