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.CSF_M_INVENTORY_V

Object Details

Object Name:	CSF_M_INVENTORY_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

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

This view stores the information about the relationship between a resource(typically and engineer) and a subinventory/locator

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ACCESS_ID	NUMBER		Yes	The Unique Access Identifier
GEN_PK	NUMBER		Yes	Gen PK
INVENTORY_ITEM_ID	NUMBER			The inventory item identifier
SUBINVENTORY_CODE	VARCHAR2	(10)		Sub Inventory Code
QUANTITY	NUMBER			The Quantity of the Item
INVENTORY_NAME	VARCHAR2	(40)		Inventory Name
SERIAL_NUMBER_CONTROL_CODE	NUMBER			The Serial Number Control Code
DESCRIPTION	VARCHAR2	(240)		Description
UOM_CODE	VARCHAR2	(3)		Code of the Unit of Measure
LOCATOR_ID	NUMBER			Locator Identifier
REVISION	VARCHAR2	(3)		Revision
LOT_NUMBER	VARCHAR2	(80)		Lot Number
ORGANIZATION_ID	NUMBER		Yes	Organisation Identifier
COMMS_NL_TRACKABLE_FLAG	VARCHAR2	(1)		Comms NL trackable Flag
MATERIAL_BILLABLE_FLAG	VARCHAR2	(30)
BILLING_CATEGORY	VARCHAR2	(4000)
RESTRICT_LOCATORS_CODE	NUMBER
LOCATION_CONTROL_CODE	NUMBER
RESTRICT_SUBINVENTORIES_CODE	NUMBER
RECOVERED_PART_DISP_CODE	VARCHAR2	(30)

Query Text

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


SELECT ACCESS_ID
,      GEN_PK
,      INVENTORY_ITEM_ID
,      SUBINVENTORY_CODE
,      QUANTITY
,      INVENTORY_NAME
,      SERIAL_NUMBER_CONTROL_CODE
,      DESCRIPTION
,      UOM_CODE
,      LOCATOR_ID
,      REVISION
,      LOT_NUMBER
,      ORGANIZATION_ID
,      COMMS_NL_TRACKABLE_FLAG
,      MATERIAL_BILLABLE_FLAG
,      BILLING_CATEGORY
,      RESTRICT_LOCATORS_CODE
,      LOCATION_CONTROL_CODE
,      RESTRICT_SUBINVENTORIES_CODE
,      RECOVERED_PART_DISP_CODE
FROM APPS.CSF_M_INVENTORY_V;

Dependencies

[top of page]

APPS.CSF_M_INVENTORY_V references the following:

APPS: ASG_BASE - show dependent code; CSM_MTL_ONHAND_QTY_ACC; CSM_UTIL_PKG - show dependent code; MTL_SYSTEM_ITEMS_KFV; MTL_SYSTEM_ITEMS_TL

APPS.CSF_M_INVENTORY_V is not referenced by any database object