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_MFG_SKU_ITEM

Object Details

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

Error table that stores error records from DDR_I_MFG_SKU_ITEM

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.
MFG_SKU_ITEM_NBR	VARCHAR2	(30)		Manufacturer 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
MFG_SKU_ITEM_NAME	VARCHAR2	(240)		Manufacturer SKU Item name
MFG_SKU_ITEM_DESC	VARCHAR2	(240)		Manufacturer SKU Item description
MFG_SKU_ITEM_TYP_CD	VARCHAR2	(30)		Unique Identifier to determine the type of SKUITEM
UOM_CD	VARCHAR2	(30)		Primary Unit of measure code
ALT_UOM_CD	VARCHAR2	(30)		Alternate Unit of measure code
UNIT_PRICE_FCTR	NUMBER	(15)		The number of units of measure per selling unit
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_BASE_COST_AMT	NUMBER			The base cost per sell unit derived from the last receipt of this item.
SU_LAST_RCVD_BASE_COST_AMT_LCL	NUMBER			The base cost per sell unit derived from the last receipt of this item in local currency.
SU_LAST_RCVD_BASE_COST_AMT_RPT	NUMBER			The base cost per sell unit derived from the last receipt of this item in Reporting currency.
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.
SU_LNDED_COST_AMT	NUMBER			The cost of the item plus the insurance, drayage, cartage, delivery, insurance, customs duties, etc.
SU_LNDED_COST_AMT_LCL	NUMBER			The cost of the item plus the insurance, drayage, cartage, delivery, insurance, customs duties, etc. in local currency.
SU_LNDED_COST_AMT_RPT	NUMBER			The cost of the item plus the insurance, drayage, cartage, delivery, insurance, customs duties, etc. 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_FIBER_CD	VARCHAR2	(30)		Unique identifier for the stock item fiber
STCK_ITEM_FABRIC_CD	VARCHAR2	(30)		Unique identifier for the stock item fabric
PKG_SZ	VARCHAR2	(30)		The size of the product printed on any packaging.
FCTR_FORMULA	NUMBER			The conversion factor used for conversion from primary UOM to secondary UOM
MFG_VRTY_NBR_1	VARCHAR2	(30)		Item attribute other than size, weight, and style, such as color.
MFG_VRTY_DESC_1	VARCHAR2	(240)		Item attribute description other than size, weight, and style, such as color.
MFG_VRTY_NBR_2	VARCHAR2	(30)		Item attribute other than size, weight, and style, such as color.
MFG_VRTY_DESC_2	VARCHAR2	(240)		Item attribute description other than size, weight, and style, such as color.
MFG_VRTY_NBR_3	VARCHAR2	(30)		Item attribute other than size, weight, and style, such as color.
MFG_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
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
ATTRIBUTE1	VARCHAR2	(240)		User defined attribute
ATTRIBUTE2	VARCHAR2	(240)		User defined attribute
ATTRIBUTE3	VARCHAR2	(240)		User defined attribute
ATTRIBUTE4	VARCHAR2	(240)		User defined attribute
ATTRIBUTE5	VARCHAR2	(240)		User defined attribute
ATTRIBUTE6	VARCHAR2	(240)		User defined attribute
ATTRIBUTE7	VARCHAR2	(240)		User defined attribute
ATTRIBUTE8	VARCHAR2	(240)		User defined attribute
ATTRIBUTE9	VARCHAR2	(240)		User defined attribute
ATTRIBUTE10	VARCHAR2	(240)		User defined attribute
ATTRIBUTE11	NUMBER			User defined attribute
ATTRIBUTE12	NUMBER			User defined attribute
ATTRIBUTE13	NUMBER			User defined attribute
ATTRIBUTE14	NUMBER			User defined attribute
ATTRIBUTE15	NUMBER			User defined attribute
ATTRIBUTE16	NUMBER			User defined attribute
ATTRIBUTE17	NUMBER			User defined attribute
ATTRIBUTE18	NUMBER			User defined attribute
ATTRIBUTE19	NUMBER			User defined attribute
ATTRIBUTE20	NUMBER			User defined attribute

Query Text

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


SELECT REC_ID
,      MFG_SKU_ITEM_NBR
,      GLBL_ITEM_ID
,      GLBL_ITEM_ID_TYP
,      MFG_SKU_ITEM_NAME
,      MFG_SKU_ITEM_DESC
,      MFG_SKU_ITEM_TYP_CD
,      UOM_CD
,      ALT_UOM_CD
,      UNIT_PRICE_FCTR
,      AVLBL_FOR_SL_DT
,      SU_LAST_RCVD_COST_ESTBL_DT
,      SU_LAST_RCVD_BASE_COST_AMT
,      SU_LAST_RCVD_BASE_COST_AMT_LCL
,      SU_LAST_RCVD_BASE_COST_AMT_RPT
,      SU_LAST_RCVD_NET_COST_AMT
,      SU_LAST_RCVD_NET_COST_AMT_LCL
,      SU_LAST_RCVD_NET_COST_AMT_RPT
,      SU_LNDED_COST_AMT
,      SU_LNDED_COST_AMT_LCL
,      SU_LNDED_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_FIBER_CD
,      STCK_ITEM_FABRIC_CD
,      PKG_SZ
,      FCTR_FORMULA
,      MFG_VRTY_NBR_1
,      MFG_VRTY_DESC_1
,      MFG_VRTY_NBR_2
,      MFG_VRTY_DESC_2
,      MFG_VRTY_NBR_3
,      MFG_VRTY_DESC_3
,      SRC_SYS_IDNT
,      SRC_SYS_DT
,      ERR_REASON
,      ACTION_FLAG
,      LOAD_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
FROM DDR.DDR_E_MFG_SKU_ITEM;

Dependencies

[top of page]

DDR.DDR_E_MFG_SKU_ITEM does not reference any database object

DDR.DDR_E_MFG_SKU_ITEM is referenced by following:

DDR: DDR_E_MFG_SKU_ITEM#