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: ViewCLN.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:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_LOCATIONS_ALL
SynonymMTL_ITEM_REVISIONS
SynonymMTL_SYSTEM_ITEMS_B
SynonymMTL_SYSTEM_ITEMS_TL
ViewMTL_SYSTEM_ITEMS_VL
APPS.CLN_INVENTORY_REPORT_V is referenced by following:

SchemaAPPS
Package BodyCLN_SYNC_INVENTORY_PKG - show dependent code