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.

VIEW: APPS.GMF_XLA_ITEM_LOCATIONS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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