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.

[Home] [Help]

View: GMF_XLA_ITEM_LOCATIONS_V

Product:	GMF - Process Manufacturing Financials
Description:	View for SLA ADR sources from Inventory Item Locations
Implementation/DBA Data:	APPS.GMF_XLA_ITEM_LOCATIONS_V

View Text

SELECT INVENTORY_LOCATION_ID LOCATOR_ID
, ORGANIZATION_ID ORGANIZATION_ID
, NULL LOCATOR_CONCAT_SEGMENTS
, SEGMENT1 LOCATOR_SEGMENT1
, SEGMENT2 LOCATOR_SEGMENT2
, SEGMENT3 LOCATOR_SEGMENT3
, SEGMENT4 LOCATOR_SEGMENT4
, SEGMENT5 LOCATOR_SEGMENT5
, SEGMENT6 LOCATOR_SEGMENT6
, SEGMENT7 LOCATOR_SEGMENT7
, SEGMENT8 LOCATOR_SEGMENT8
, SEGMENT9 LOCATOR_SEGMENT9
, SEGMENT10 LOCATOR_SEGMENT10
, SEGMENT11 LOCATOR_SEGMENT11
, SEGMENT12 LOCATOR_SEGMENT12
, SEGMENT13 LOCATOR_SEGMENT13
, SEGMENT14 LOCATOR_SEGMENT14
, SEGMENT15 LOCATOR_SEGMENT15
, SEGMENT16 LOCATOR_SEGMENT16
, SEGMENT17 LOCATOR_SEGMENT17
, SEGMENT18 LOCATOR_SEGMENT18
, SEGMENT19 LOCATOR_SEGMENT19
, SEGMENT20 LOCATOR_SEGMENT20
FROM MTL_ITEM_LOCATIONS

Columns

Name
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