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_I_RTL_SKU_ITEM

Object Details

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

Interface table to populate data in DDR_R_RTL_SKU_ITEM

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
DDR_I_RTL_SKU_ITEM_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REC_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REC_ID	NUMBER		Yes	Record ID, uniquely identify each records.
RTL_ORG_CD	VARCHAR2	(30)		Retail organization 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
RTL_SKU_ITEM_TYP_CD	VARCHAR2	(30)		Type of retail SKU item
UOM_CD	VARCHAR2	(30)		Unit of measure
RTL_SKU_ITEM_INDSTRY_IDNT_CD	VARCHAR2	(30)		Retail SKU Item Industry Identification code
AVLBL_FOR_SL_DT	DATE			Date on which this sku item becomes available for sale
SU_LAST_RCVD_COST_ESTBL_DT	DATE			The date the last received costs (net and base) were established.
SU_LAST_RCVD_NET_COST_AMT	NUMBER			The net cost per sell unit derived from the last receipt of this item.
SU_LAST_RCVD_NET_COST_AMT_LCL	NUMBER			The net cost per sell unit derived from the last receipt of this item in local currency.
SU_LAST_RCVD_NET_COST_AMT_RPT	NUMBER			The net cost per sell unit derived from the last receipt of this item in reporting currency.
STCK_ITEM_TYP_CD	VARCHAR2	(30)		Unique identifier for type of stock item
SZ_TYP_CD	VARCHAR2	(30)		Unique number for the size type
STCK_ITEM_STYLE_CD	VARCHAR2	(30)		Unique identifier for the stock item style
STCK_ITEM_DYE_CD	VARCHAR2	(30)		Unique identifier for the stock item dye
STCK_ITEM_COLOR_CD	VARCHAR2	(30)		Unique identifier for the stock item color
STCK_ITEM_COATING_CD	VARCHAR2	(30)		Unique identifier for the stock item coating
STCK_ITEM_WEAVE_CD	VARCHAR2	(30)		Unique identifier for the stock item weave
STCK_ITEM_FABRIC_CD	VARCHAR2	(30)		Unique identifier for the stock item fabric
STCK_ITEM_FIBER_CD	VARCHAR2	(30)		Unique identifier for the stock item fiber
PCK_SELLBL_CD	VARCHAR2	(30)		Indicates whether the pack is sellable.
PCK_SELLBL_DESC	VARCHAR2	(240)		The pack sellable description. Valid descriptions are: Sellable, Non-sellable.
PCK_SMPL_CD	VARCHAR2	(30)		Indicates whether the pack is simple.
PCK_SMPL_DESC	VARCHAR2	(240)		The pack simple description. Valid descriptions are: Simple, complex.
PCK_ORDRBL_CD	VARCHAR2	(30)		The abbreviated code for the pack order type
PCK_ORDRBL_DESC	VARCHAR2	(240)		The pack order type description.
PCK_IND	VARCHAR2	(1)		Indicates if the item is a pack.
PKG_SZ	VARCHAR2	(30)		The size of the product printed on any packaging.
RTL_VRTY_NBR_1	VARCHAR2	(30)		Item attribute other than size, weight, and style, such as color.
RTL_VRTY_DESC_1	VARCHAR2	(240)		Item attribute description other than size, weight, and style, such as color.
RTL_VRTY_NBR_2	VARCHAR2	(30)		Item attribute other than size, weight, and style, such as color.
RTL_VRTY_DESC_2	VARCHAR2	(240)		Item attribute description other than size, weight, and style, such as color.
RTL_VRTY_NBR_3	VARCHAR2	(30)		Item attribute other than size, weight, and style, such as color.
RTL_VRTY_DESC_3	VARCHAR2	(240)		Item attribute description other than size, weight, and style, such as color.
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_ORG_CD
,      RTL_SKU_ITEM_NBR
,      GLBL_ITEM_ID
,      GLBL_ITEM_ID_TYP
,      RTL_SKU_ITEM_NAME
,      RTL_SKU_ITEM_DESC
,      RTL_SKU_ITEM_TYP_CD
,      UOM_CD
,      RTL_SKU_ITEM_INDSTRY_IDNT_CD
,      AVLBL_FOR_SL_DT
,      SU_LAST_RCVD_COST_ESTBL_DT
,      SU_LAST_RCVD_NET_COST_AMT
,      SU_LAST_RCVD_NET_COST_AMT_LCL
,      SU_LAST_RCVD_NET_COST_AMT_RPT
,      STCK_ITEM_TYP_CD
,      SZ_TYP_CD
,      STCK_ITEM_STYLE_CD
,      STCK_ITEM_DYE_CD
,      STCK_ITEM_COLOR_CD
,      STCK_ITEM_COATING_CD
,      STCK_ITEM_WEAVE_CD
,      STCK_ITEM_FABRIC_CD
,      STCK_ITEM_FIBER_CD
,      PCK_SELLBL_CD
,      PCK_SELLBL_DESC
,      PCK_SMPL_CD
,      PCK_SMPL_DESC
,      PCK_ORDRBL_CD
,      PCK_ORDRBL_DESC
,      PCK_IND
,      PKG_SZ
,      RTL_VRTY_NBR_1
,      RTL_VRTY_DESC_1
,      RTL_VRTY_NBR_2
,      RTL_VRTY_DESC_2
,      RTL_VRTY_NBR_3
,      RTL_VRTY_DESC_3
,      SRC_SYS_IDNT
,      SRC_SYS_DT
FROM DDR.DDR_I_RTL_SKU_ITEM;

Dependencies

[top of page]

DDR.DDR_I_RTL_SKU_ITEM does not reference any database object

DDR.DDR_I_RTL_SKU_ITEM is referenced by following:

APPS: DDR_I_RTL_SKU_ITEM