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

Object Details

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

View Type

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

Mobile view on MTL_ITEM_LOCATIONS

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INVENTORY_LOCATION_ID	NUMBER		Yes	Inventory Location Id
ORGANIZATION_ID	NUMBER		Yes	Organization Id
CONCATENATED_SEGMENTS	CHAR	(1)		Concatenated Segments
PADDED_CONCATENATED_SEGMENTS	CHAR	(1)		Padded Concatenated Segments
DESCRIPTION	VARCHAR2	(50)		Description
SUBINVENTORY_CODE	VARCHAR2	(10)		Subinventory Code
DISABLE_DATE	DATE			Disable Date
START_DATE_ACTIVE	DATE			Start Date Active
END_DATE_ACTIVE	DATE			End Date Active
ENABLED_FLAG	VARCHAR2	(1)	Yes	Enabled Flag
SUMMARY_FLAG	VARCHAR2	(1)	Yes	Summary Flag
DESCRIPTIVE_TEXT	VARCHAR2	(240)		Descriptive Text
PROJECT_ID	NUMBER	(15)		Project Id
TASK_ID	NUMBER	(15)		Task Id
PHYSICAL_LOCATION_ID	NUMBER	(15)		Physical Location Id
STATUS_ID	NUMBER			Status Id
LOCATOR_STATUS	NUMBER			Locator Status
LOCATION_CURRENT_UNITS	NUMBER			Location Current Units
LOCATION_AVAILABLE_UNITS	NUMBER			Location Available Units
INVENTORY_ITEM_ID	NUMBER			Inventory Item Id
LOCATION_SUGGESTED_UNITS	NUMBER			Location Suggested Units
ACCESS_ID	NUMBER			Access Id

Query Text

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


SELECT INVENTORY_LOCATION_ID
,      ORGANIZATION_ID
,      CONCATENATED_SEGMENTS
,      PADDED_CONCATENATED_SEGMENTS
,      DESCRIPTION
,      SUBINVENTORY_CODE
,      DISABLE_DATE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ENABLED_FLAG
,      SUMMARY_FLAG
,      DESCRIPTIVE_TEXT
,      PROJECT_ID
,      TASK_ID
,      PHYSICAL_LOCATION_ID
,      STATUS_ID
,      LOCATOR_STATUS
,      LOCATION_CURRENT_UNITS
,      LOCATION_AVAILABLE_UNITS
,      INVENTORY_ITEM_ID
,      LOCATION_SUGGESTED_UNITS
,      ACCESS_ID
FROM APPS.CSL_MTL_ITEM_LOCATIONS_V;

Dependencies

[top of page]

APPS.CSL_MTL_ITEM_LOCATIONS_V references the following:

APPS: ASG_BASE - show dependent code; CSL_MTL_ITEM_LOCATIONS_ACC; MTL_ITEM_LOCATIONS_KFV

APPS.CSL_MTL_ITEM_LOCATIONS_V is not referenced by any database object