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_RTL_ITEM_HCHY

Object Details

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

Error table that stores error records from DDR_E_RTL_ITEM_HCHY

Storage Details

Tablespace:	APPS_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_CMPNY_CD	VARCHAR2	(30)		Retail Item company code
RTL_DIV_CD	VARCHAR2	(30)		Retail Item Division code
RTL_DIV_NAME	VARCHAR2	(40)		Retail Item Division name
RTL_DIV_BYR_NAME	VARCHAR2	(40)		Retail Item Division buyer name
RTL_DIV_MRCHNDSR_NAME	VARCHAR2	(40)		Retail Item Division merchandiser name
RTL_GRP_CD	VARCHAR2	(30)		Retail Item group code
RTL_GRP_NAME	VARCHAR2	(40)		Retail Item group name
RTL_GRP_BYR_NAME	VARCHAR2	(40)		Retail Item group buyer name
RTL_GRP_MRCHNDSR_NAME	VARCHAR2	(40)		Retail Item group merchandiser name
RTL_DEPT_CD	VARCHAR2	(30)		Retail Item Department code
RTL_DEPT_NAME	VARCHAR2	(40)		Retail Item Department name
RTL_DEPT_BYR_NAME	VARCHAR2	(40)		Retail Item Department buyer name
RTL_DEPT_MRCHNDSR_NAME	VARCHAR2	(40)		Retail Item Department merchandiser name
RTL_CLASS_CD	VARCHAR2	(30)		Retail Item Class code
RTL_CLASS_NAME	VARCHAR2	(40)		Retail Item Class name
RTL_CLASS_BYR_NAME	VARCHAR2	(40)		Retail Item Class buyer name
RTL_CLASS_MRCHNDSR_NAME	VARCHAR2	(40)		Retail Item Class merchandiser name
RTL_SBC_CD	VARCHAR2	(30)		Retail Item Sub-class code
RTL_SBC_NAME	VARCHAR2	(40)		Retail Item Sub-class name
RTL_SBC_BYR_NAME	VARCHAR2	(40)		Retail Item Sub-class buyer name
RTL_SBC_MRCHNDSR_NAME	VARCHAR2	(40)		Retail Item Sub-class merchandiser name
RTL_ITEM_NBR	VARCHAR2	(30)		Retail Item number
RTL_ITEM_NAME	VARCHAR2	(40)		Retail Item name
RTL_ITEM_DESC	VARCHAR2	(240)		Retail Item description
RTL_BRND_CD	VARCHAR2	(30)		Retailer brand code
RTL_SKU_ITEM_NBR	VARCHAR2	(30)		Retail SKU Item number
GLBL_ITEM_ID	VARCHAR2	(30)		Universally Unique Global Item ID for an SKU for Mapping Manufacturer SKU to Retailer SKU: Example - 14-digit Global Trade Item Number (GTIN) assigned by the GS1 standards organization
GLBL_ITEM_ID_TYP	VARCHAR2	(30)		An indicator of the identification scheme used to assign the global item number. By default, the value is GTIN if unspecified
RTL_SKU_ITEM_NAME	VARCHAR2	(40)		Retail SKU Item name
RTL_SKU_ITEM_DESC	VARCHAR2	(240)		Retail SKU Item 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
,      RTL_CMPNY_CD
,      RTL_DIV_CD
,      RTL_DIV_NAME
,      RTL_DIV_BYR_NAME
,      RTL_DIV_MRCHNDSR_NAME
,      RTL_GRP_CD
,      RTL_GRP_NAME
,      RTL_GRP_BYR_NAME
,      RTL_GRP_MRCHNDSR_NAME
,      RTL_DEPT_CD
,      RTL_DEPT_NAME
,      RTL_DEPT_BYR_NAME
,      RTL_DEPT_MRCHNDSR_NAME
,      RTL_CLASS_CD
,      RTL_CLASS_NAME
,      RTL_CLASS_BYR_NAME
,      RTL_CLASS_MRCHNDSR_NAME
,      RTL_SBC_CD
,      RTL_SBC_NAME
,      RTL_SBC_BYR_NAME
,      RTL_SBC_MRCHNDSR_NAME
,      RTL_ITEM_NBR
,      RTL_ITEM_NAME
,      RTL_ITEM_DESC
,      RTL_BRND_CD
,      RTL_SKU_ITEM_NBR
,      GLBL_ITEM_ID
,      GLBL_ITEM_ID_TYP
,      RTL_SKU_ITEM_NAME
,      RTL_SKU_ITEM_DESC
,      SRC_SYS_IDNT
,      SRC_SYS_DT
,      ERR_REASON
,      ACTION_FLAG
,      LOAD_ID
FROM DDR.DDR_E_RTL_ITEM_HCHY;

Dependencies

[top of page]

DDR.DDR_E_RTL_ITEM_HCHY does not reference any database object

DDR.DDR_E_RTL_ITEM_HCHY is referenced by following:

APPS: DDR_E_RTL_ITEM_HCHY