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_INVENTORY_REPORT_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view is used for mapping purposes in PIP-4C1

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
START_DATE_ACTIVE	DATE			Start Active Date
INVENTORY_ITEM_STATUS_CODE	VARCHAR2	(10)	Yes	Status Code Of The Inventory Item
ITEM_TYPE	VARCHAR2	(30)		Item Type
PRIMARY_UOM_CODE	VARCHAR2	(3)		Unit Of Measure
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory Item ID
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attrbute Category
ATTRIBUTE1	VARCHAR2	(240)		Attribute 1
ATTRIBUTE2	VARCHAR2	(240)		Attribute 2
ATTRIBUTE3	VARCHAR2	(240)		Attribute 3
ATTRIBUTE4	VARCHAR2	(240)		Attribute 4
ATTRIBUTE5	VARCHAR2	(240)		Attribute 5
ATTRIBUTE6	VARCHAR2	(240)		Attribute 6
ATTRIBUTE7	VARCHAR2	(240)		Attribute 7
ATTRIBUTE8	VARCHAR2	(240)		Attribute 8
ATTRIBUTE9	VARCHAR2	(240)		Attribute 9
ATTRIBUTE10	VARCHAR2	(240)		Attribute 10
ATTRIBUTE11	VARCHAR2	(240)		Attribute 11
ATTRIBUTE12	VARCHAR2	(240)		Attribute 12
ATTRIBUTE13	VARCHAR2	(240)		Attribute 13
ATTRIBUTE14	VARCHAR2	(240)		Attribute 14
ATTRIBUTE15	VARCHAR2	(240)		Attribute 15
END_DATE_ACTIVE	DATE			End Date Active
DESCRIPTION	VARCHAR2	(240)		Description
REVISION_ID	NUMBER			Revision ID
REVISION	VARCHAR2	(3)		Revision
ORGANIZATION_ID	NUMBER		Yes	Organization ID
NAME	VARCHAR2	(240)	Yes	Name
ECE_TP_LOCATION_CODE	VARCHAR2	(35)		Trading Partner Location Code
ADDRESS_LINE_1	VARCHAR2	(240)		Address Line 1
ADDRESS_LINE_2	VARCHAR2	(240)		Address Line 2
ADDRESS_LINE_3	VARCHAR2	(240)		Address Line 3
TOWN_OR_CITY	VARCHAR2	(30)		Town or City
COUNTRY	VARCHAR2	(60)		Country
POSTAL_CODE	VARCHAR2	(30)		Postal Code
CONCATENATED_SEGMENTS	VARCHAR2	(40)		Concatenated Segments
REVISION_QTY_CONTROL_CODE	NUMBER			Revision Quantity Control Code
LOT_CONTROL_CODE	NUMBER			Code for checking whether an item is Lot Controlled or not

Query Text

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


SELECT START_DATE_ACTIVE
,      INVENTORY_ITEM_STATUS_CODE
,      ITEM_TYPE
,      PRIMARY_UOM_CODE
,      INVENTORY_ITEM_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      END_DATE_ACTIVE
,      DESCRIPTION
,      REVISION_ID
,      REVISION
,      ORGANIZATION_ID
,      NAME
,      ECE_TP_LOCATION_CODE
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      TOWN_OR_CITY
,      COUNTRY
,      POSTAL_CODE
,      CONCATENATED_SEGMENTS
,      REVISION_QTY_CONTROL_CODE
,      LOT_CONTROL_CODE
FROM APPS.CLN_INVENTORY_REPORT_V;

Dependencies

[top of page]

APPS.CLN_INVENTORY_REPORT_V references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; HR_LOCATIONS_ALL; MTL_ITEM_REVISIONS; MTL_SYSTEM_ITEMS_B; MTL_SYSTEM_ITEMS_TL; MTL_SYSTEM_ITEMS_VL

APPS.CLN_INVENTORY_REPORT_V is referenced by following:

APPS: CLN_SYNC_INVENTORY_PKG - show dependent code