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.

APPS.WMS_RULE_4 dependencies on MTL_SERIAL_NUMBERS

Line 81: from MTL_SERIAL_NUMBERS msn

77: ,base.secondary_quantity
78: ,base.grade_code
79: ,NULL consist_string
80: ,msn.SERIAL_NUMBER order_by_string
81: from MTL_SERIAL_NUMBERS msn
82: ,MTL_SYSTEM_ITEMS msi
83: ,WMS_TRX_DETAILS_TMP_V mptdtv
84: ,(
85: select msn.current_organization_id organization_id

Line 113: from mtl_serial_numbers msn

109: ,loc.task_id task_id
110: ,NULL locator_inventory_item_id
111: ,NULL empty_flag
112: ,NULL location_current_units
113: from mtl_serial_numbers msn
114: ,mtl_secondary_inventories sub
115: ,mtl_item_locations loc
116: ,mtl_lot_numbers lot
117: where msn.current_status = 3

Line 175: from MTL_SERIAL_NUMBERS msn

171: ,sum(base.secondary_quantity)
172: ,base.grade_code
173: ,NULL consist_string
174: ,msn.SERIAL_NUMBER order_by_string
175: from MTL_SERIAL_NUMBERS msn
176: ,MTL_SYSTEM_ITEMS msi
177: ,WMS_TRX_DETAILS_TMP_V mptdtv
178: ,(
179: select msn.current_organization_id organization_id

Line 207: from mtl_serial_numbers msn

203: ,loc.task_id task_id
204: ,NULL locator_inventory_item_id
205: ,NULL empty_flag
206: ,NULL location_current_units
207: from mtl_serial_numbers msn
208: ,mtl_secondary_inventories sub
209: ,mtl_item_locations loc
210: ,mtl_lot_numbers lot
211: where msn.current_status = 3

Line 286: from MTL_SERIAL_NUMBERS msn

282: ,sum(base.secondary_quantity)
283: ,base.grade_code
284: ,NULL consist_string
285: ,msn.SERIAL_NUMBER order_by_string
286: from MTL_SERIAL_NUMBERS msn
287: ,MTL_SYSTEM_ITEMS msi
288: ,WMS_TRX_DETAILS_TMP_V mptdtv
289: ,(
290: select msn.current_organization_id organization_id

Line 318: from mtl_serial_numbers msn

314: ,loc.task_id task_id
315: ,NULL locator_inventory_item_id
316: ,NULL empty_flag
317: ,NULL location_current_units
318: from mtl_serial_numbers msn
319: ,mtl_secondary_inventories sub
320: ,mtl_item_locations loc
321: ,mtl_lot_numbers lot
322: where msn.current_status = 3

Line 394: from MTL_SERIAL_NUMBERS msn

390: ,sum(base.secondary_quantity)
391: ,base.grade_code
392: ,NULL consist_string
393: ,msn.SERIAL_NUMBER order_by_string
394: from MTL_SERIAL_NUMBERS msn
395: ,MTL_SYSTEM_ITEMS msi
396: ,WMS_TRX_DETAILS_TMP_V mptdtv
397: ,(
398: SELECT x.organization_id organization_id