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

TABLE: DDR.DDR_I_RTL_ITEM_HCHY

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


Interface table to populate data in retailers item hierarchy


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DDR_I_RTL_ITEM_HCHY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREC_ID
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
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
FROM DDR.DDR_I_RTL_ITEM_HCHY;

Dependencies

[top of page]

DDR.DDR_I_RTL_ITEM_HCHY does not reference any database object

DDR.DDR_I_RTL_ITEM_HCHY is referenced by following:

SchemaDDR
ViewDDR_I_RTL_ITEM_HCHY#