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

Object Details

Object Name:	GMF_XLA_ITEM_LOCATIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMF.GMF_XLA_ITEM_LOCATIONS_V
Subobject Name:
Status:	VALID

View Type

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

View for SLA ADR sources from Inventory Item Locations

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LOCATOR_ID	NUMBER		Yes	Locator identifier
ORGANIZATION_ID	NUMBER		Yes	Inventory Organization identifier
LOCATOR_CONCAT_SEGMENTS	VARCHAR2	(0)		Locator concatenated segment value
LOCATOR_SEGMENT1	VARCHAR2	(40)		Locator segment1
LOCATOR_SEGMENT2	VARCHAR2	(40)		Locator segment2
LOCATOR_SEGMENT3	VARCHAR2	(40)		Locator segment3
LOCATOR_SEGMENT4	VARCHAR2	(40)		Locator segment4
LOCATOR_SEGMENT5	VARCHAR2	(40)		Locator segment5
LOCATOR_SEGMENT6	VARCHAR2	(40)		Locator segment6
LOCATOR_SEGMENT7	VARCHAR2	(40)		Locator segment7
LOCATOR_SEGMENT8	VARCHAR2	(40)		Locator segment8
LOCATOR_SEGMENT9	VARCHAR2	(40)		Locator segment9
LOCATOR_SEGMENT10	VARCHAR2	(40)		Locator segment10
LOCATOR_SEGMENT11	VARCHAR2	(40)		Locator segment11
LOCATOR_SEGMENT12	VARCHAR2	(40)		Locator segment12
LOCATOR_SEGMENT13	VARCHAR2	(40)		Locator segment13
LOCATOR_SEGMENT14	VARCHAR2	(40)		Locator segment14
LOCATOR_SEGMENT15	VARCHAR2	(40)		Locator segment15
LOCATOR_SEGMENT16	VARCHAR2	(40)		Locator segment16
LOCATOR_SEGMENT17	VARCHAR2	(40)		Locator segment17
LOCATOR_SEGMENT18	VARCHAR2	(40)		Locator segment18
LOCATOR_SEGMENT19	VARCHAR2	(40)		Locator segment19
LOCATOR_SEGMENT20	VARCHAR2	(40)		Locator segment20

Query Text

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


SELECT LOCATOR_ID
,      ORGANIZATION_ID
,      LOCATOR_CONCAT_SEGMENTS
,      LOCATOR_SEGMENT1
,      LOCATOR_SEGMENT2
,      LOCATOR_SEGMENT3
,      LOCATOR_SEGMENT4
,      LOCATOR_SEGMENT5
,      LOCATOR_SEGMENT6
,      LOCATOR_SEGMENT7
,      LOCATOR_SEGMENT8
,      LOCATOR_SEGMENT9
,      LOCATOR_SEGMENT10
,      LOCATOR_SEGMENT11
,      LOCATOR_SEGMENT12
,      LOCATOR_SEGMENT13
,      LOCATOR_SEGMENT14
,      LOCATOR_SEGMENT15
,      LOCATOR_SEGMENT16
,      LOCATOR_SEGMENT17
,      LOCATOR_SEGMENT18
,      LOCATOR_SEGMENT19
,      LOCATOR_SEGMENT20
FROM APPS.GMF_XLA_ITEM_LOCATIONS_V;

Dependencies

[top of page]

APPS.GMF_XLA_ITEM_LOCATIONS_V references the following:

APPS: MTL_ITEM_LOCATIONS

APPS.GMF_XLA_ITEM_LOCATIONS_V is not referenced by any database object