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]

VIEW: APPS.CLN_ITEMMST_ITEMHEADER_V

Object Details

Object Name:	CLN_ITEMMST_ITEMHEADER_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CLN.CLN_ITEMMST_ITEMHEADER_V
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

View for the Header section of the Sync Item XML message

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory Item ID.
START_DATE_ACTIVE	DATE			Start Date that item is considered active.
UNIT_HEIGHT	NUMBER			Unit Height.
DIMENSION_UOM_CODE	VARCHAR2	(3)		Dimension Unit of Measure.
UNIT_LENGTH	NUMBER			Unit Length.
UNIT_VOLUME	NUMBER			Unit Volume.
VOLUME_UOM_CODE	VARCHAR2	(3)		Volume Unit of Measure.
UNIT_WEIGHT	NUMBER			Unit Weight.
WEIGHT_UOM_CODE	VARCHAR2	(3)		Weight Unit of Measure.
UNIT_WIDTH	NUMBER			Unit Width.
CONCATENATED_SEGMENTS	VARCHAR2	(40)		Display Name of Item.
ITEM_TYPE	VARCHAR2	(30)		Item Type.
PRIMARY_UOM_CODE	VARCHAR2	(3)		Primary Unit of Measure.
BOM_ITEM_TYPE	NUMBER		Yes	BOM Item Type.
INVENTORY_ITEM_STATUS_CODE	VARCHAR2	(10)	Yes	Inventory Item Status Code.
ORGANIZATION_ID	NUMBER		Yes	Organization ID.
COST_OF_SALES_ACCOUNT	NUMBER			Cost of Sales Account.
SAFETY_STOCK_BUCKET_DAYS	NUMBER			Safety Stock Bucket Days.
CUMULATIVE_TOTAL_LEAD_TIME	NUMBER			Cumulative Total Lead Time.
PLANNING_TIME_FENCE_DAYS	NUMBER			Planning Time Fence Days.
MINIMUM_ORDER_QUANTITY	NUMBER			Minimum Order Quantity.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute Category.
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield Segment.
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield Segment.
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield Segment.
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield Segment.
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield Segment.
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield Segment.
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield Segment.
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield Segment.
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield Segment.
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield Segment.
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield Segment.
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield Segment.
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield Segment.
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield Segment.
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield Segment.
ITEM_DESCRIPTION	VARCHAR2	(240)		Item Description.
REVISION	VARCHAR2	(3)		Item Revision.
EFFECTIVITY_DATE	DATE			Effectivity Date.
ITEM_CATALOG_GROUP_ID	NUMBER			Item Catalog Group ID.
CUSTOMER_ITEM_NUMBER	VARCHAR2	(50)		Customer Item Number.
CUSTOMER_ID	NUMBER
HAZARD_CLASS	VARCHAR2	(40)		Hazard Class.

Query Text

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


SELECT INVENTORY_ITEM_ID
,      START_DATE_ACTIVE
,      UNIT_HEIGHT
,      DIMENSION_UOM_CODE
,      UNIT_LENGTH
,      UNIT_VOLUME
,      VOLUME_UOM_CODE
,      UNIT_WEIGHT
,      WEIGHT_UOM_CODE
,      UNIT_WIDTH
,      CONCATENATED_SEGMENTS
,      ITEM_TYPE
,      PRIMARY_UOM_CODE
,      BOM_ITEM_TYPE
,      INVENTORY_ITEM_STATUS_CODE
,      ORGANIZATION_ID
,      COST_OF_SALES_ACCOUNT
,      SAFETY_STOCK_BUCKET_DAYS
,      CUMULATIVE_TOTAL_LEAD_TIME
,      PLANNING_TIME_FENCE_DAYS
,      MINIMUM_ORDER_QUANTITY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ITEM_DESCRIPTION
,      REVISION
,      EFFECTIVITY_DATE
,      ITEM_CATALOG_GROUP_ID
,      CUSTOMER_ITEM_NUMBER
,      CUSTOMER_ID
,      HAZARD_CLASS
FROM APPS.CLN_ITEMMST_ITEMHEADER_V;

Dependencies

[top of page]

APPS.CLN_ITEMMST_ITEMHEADER_V references the following:

APPS: ARP_ADDR_PKG - show dependent code; CLN_SYNCITEM_PKG - show dependent code; FND_PROFILE - show dependent code; MTL_CUSTOMER_ITEM_XREFS_V; MTL_ITEM_REVISIONS; MTL_SYSTEM_ITEMS_VL; PO_HAZARD_CLASSES_TL

APPS.CLN_ITEMMST_ITEMHEADER_V is referenced by following:

APPS: CLN_SYNCITEM_PKG - show dependent code