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_MFG_SKU_ITEM

Object Details

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

Lowest level of Manufacturer Item Hierarchy. The unit identification that is used to track manufacturers items

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
DDR_R_MFG_SKU_ITEM_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	MFG_SKU_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MFG_ORG_CD	VARCHAR2	(30)	Yes	Manufacturer Organization Code
MFG_SKU_ITEM_ID	NUMBER		Yes	Manufacturer SKU Item ID
MFG_SKU_ITEM_NBR	VARCHAR2	(30)	Yes	Unique Manufacturer proprietary SKU Item Number
ORG_CD	VARCHAR2	(30)	Yes	Code for Retailer Organization
GLBL_ITEM_ID	VARCHAR2	(30)	Yes	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)	Yes	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	(40)		Manufacturer SKU Item Name
MFG_SKU_ITEM_DESC	VARCHAR2	(240)		Manufacturer SKU Item Description
MFG_SKU_ITEM_LNG_DESC	VARCHAR2	(240)		Manufacturer SKU Item Long Description
MFG_SKU_ITEM_TYP_CD	VARCHAR2	(30)		Manufacturer SKU Item Type Code
MFG_ITEM_ID	NUMBER			Manufacturer Item ID
MFG_ITEM_NBR	VARCHAR2	(30)		Manufacturer Item Number
UOM_CD	VARCHAR2	(30)		Unit of measure code for the transaction
ALT_UOM_CD	VARCHAR2	(30)		Alternate unit of measure code for the transaction
UNIT_PRICE_FCTR	NUMBER			The number of units of measure per selling unit. Used as the divisor when calculating the SKU ITEMs unit retail price, eg $1.67 per pound or $2.59 for 32 floz.
RECALL_IND	VARCHAR2	(1)		A flag to indicate that the sku item has been recalled earlier
COLLCTN_SKU_FLG	VARCHAR2	(1)		Collection SKU Flag
AVLBL_FOR_SL_DT	DATE			Date item is 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. The base cost excludes allowances, discounts, charges and other amounts that may change the item cost.
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. The base cost excludes allowances, discounts, charges and other amounts that may change the item cost.
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. The base cost excludes allowances, discounts, charges and other amounts that may change the item cost.
SU_LAST_RCVD_NET_COST_AMT	NUMBER			The net cost per sell unit derived from the last receipt of this item. The net cost includes allowances, discounts, charges and other amounts that may change the item cost. Where there are no allowances, etc. the net cost will equal the base cost for an 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. The net cost includes allowances, discounts, charges and other amounts that may change the item cost. Where there are no allowances, etc. the net cost will equal the base cost for an item.
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. The net cost includes allowances, discounts, charges and other amounts that may change the item cost. Where there are no allowances, etc. the net cost will equal the base cost for an item.
SU_LNDED_COST_AMT	NUMBER			The cost of the item plus the insurance, drayage, cartage, delivery, insurance, customs duties, etc. which add up to the full delivered cost of an imported item to the store.
SU_LNDED_COST_AMT_LCL	NUMBER			The cost of the item plus the insurance, drayage, cartage, delivery, insurance, customs duties, etc. which add up to the full delivered cost of an imported item to the store, in local currency.
SU_LNDED_COST_AMT_RPT	NUMBER			The cost of the item plus the insurance, drayage, cartage, delivery, insurance, customs duties, etc. which add up to the full delivered cost of an imported item to the store, in reporting currency
STCK_ITEM_TYP_CD	VARCHAR2	(30)		Stocked Item Type Code
SZ_TYP_CD	VARCHAR2	(30)		Size Type Code
STCK_ITEM_STYLE_CD	VARCHAR2	(30)		Stocked Item Style Code
STCK_ITEM_DYE_CD	VARCHAR2	(30)		Stocked Item Dye Code
STCK_ITEM_COLOR_CD	VARCHAR2	(30)		Stocked Item Color Code
STCK_ITEM_COATING_CD	VARCHAR2	(30)		Stocked Item Coating Code
STCK_ITEM_WEAVE_CD	VARCHAR2	(30)		Stocked Item Weave Code
STCK_ITEM_FIBER_CD	VARCHAR2	(30)		Stocked Item Fiber Code
STCK_ITEM_FABRIC_CD	VARCHAR2	(30)		Stocked Item Fabric Code
PKG_SZ	VARCHAR2	(30)		Packaging Size
EFF_FROM_DT	DATE		Yes	Effective From Date
EFF_TO_DT	DATE			Effective To Date
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
CRTD_BY_DSR	VARCHAR2	(30)	Yes	User Information of who loaded the data, for auditing purpose
LAST_UPDT_BY_DSR	VARCHAR2	(30)	Yes	User Information of last updated by, for auditing purpose
CREATED_BY	NUMBER	(15)	Yes	Number code of who last loaded the data, for auditing purpose
CREATION_DATE	DATE		Yes	Date on which the data was loaded in target table, for auditing purpose
LAST_UPDATED_BY	NUMBER	(15)	Yes	Number code of who last updated the data in target table, for auditing purpose
LAST_UPDATE_DATE	DATE		Yes	Date on which the data was last updated in target table, for auditing purpose
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Login ID of the User who last updated the data in target table, for auditing purpose

Query Text

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


SELECT MFG_ORG_CD
,      MFG_SKU_ITEM_ID
,      MFG_SKU_ITEM_NBR
,      ORG_CD
,      GLBL_ITEM_ID
,      GLBL_ITEM_ID_TYP
,      MFG_SKU_ITEM_NAME
,      MFG_SKU_ITEM_DESC
,      MFG_SKU_ITEM_LNG_DESC
,      MFG_SKU_ITEM_TYP_CD
,      MFG_ITEM_ID
,      MFG_ITEM_NBR
,      UOM_CD
,      ALT_UOM_CD
,      UNIT_PRICE_FCTR
,      RECALL_IND
,      COLLCTN_SKU_FLG
,      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
,      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_MFG_SKU_ITEM;

Dependencies

[top of page]

DDR.DDR_R_MFG_SKU_ITEM does not reference any database object

DDR.DDR_R_MFG_SKU_ITEM is referenced by following:

APPS: DDR_R_MFG_ITEM_SKU_DN_MV; DDR_R_MFG_SKU_ITEM