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_17 dependencies on MTL_ITEM_LOCATIONS

Line 82: ,MTL_ITEM_LOCATIONS mil

78: ,base.grade_code
79: ,NULL consist_string
80: ,NULL order_by_string
81: from PJM_PROJECTS_ORG_V ppovs
82: ,MTL_ITEM_LOCATIONS mil
83: ,WMS_TRX_DETAILS_TMP_V mptdtv
84: ,(
85: select msn.current_organization_id organization_id
86: ,msn.inventory_item_id

Line 115: ,mtl_item_locations loc

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
118: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
119: decode(g_unit_number, '-9999', 'a', g_unit_number)

Line 173: ,MTL_ITEM_LOCATIONS mil

169: ,base.grade_code
170: ,NULL consist_string
171: ,NULL order_by_string
172: from PJM_PROJECTS_ORG_V ppovs
173: ,MTL_ITEM_LOCATIONS mil
174: ,WMS_TRX_DETAILS_TMP_V mptdtv
175: ,(
176: select msn.current_organization_id organization_id
177: ,msn.inventory_item_id

Line 206: ,mtl_item_locations loc

202: ,NULL empty_flag
203: ,NULL location_current_units
204: from mtl_serial_numbers msn
205: ,mtl_secondary_inventories sub
206: ,mtl_item_locations loc
207: ,mtl_lot_numbers lot
208: where msn.current_status = 3
209: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
210: decode(g_unit_number, '-9999', 'a', g_unit_number)

Line 280: ,MTL_ITEM_LOCATIONS mil

276: ,base.grade_code
277: ,NULL consist_string
278: ,NULL order_by_string
279: from PJM_PROJECTS_ORG_V ppovs
280: ,MTL_ITEM_LOCATIONS mil
281: ,WMS_TRX_DETAILS_TMP_V mptdtv
282: ,(
283: select msn.current_organization_id organization_id
284: ,msn.inventory_item_id

Line 313: ,mtl_item_locations loc

309: ,NULL empty_flag
310: ,NULL location_current_units
311: from mtl_serial_numbers msn
312: ,mtl_secondary_inventories sub
313: ,mtl_item_locations loc
314: ,mtl_lot_numbers lot
315: where msn.current_status = 3
316: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
317: decode(g_unit_number, '-9999', 'a', g_unit_number)

Line 384: ,MTL_ITEM_LOCATIONS mil

380: ,base.grade_code
381: ,NULL consist_string
382: ,NULL order_by_string
383: from PJM_PROJECTS_ORG_V ppovs
384: ,MTL_ITEM_LOCATIONS mil
385: ,WMS_TRX_DETAILS_TMP_V mptdtv
386: ,(
387: SELECT x.organization_id organization_id
388: ,x.inventory_item_id inventory_item_id

Line 454: mtl_onhand_quantities_detail moq,mtl_item_locations mils

450: ,moq.lpn_id lpn_id
451: ,decode(mils.project_id, mils.project_id, moq.project_id) project_id
452: ,decode(mils.task_id, mils.task_id, moq.task_id) task_id
453: FROM
454: mtl_onhand_quantities_detail moq,mtl_item_locations mils
455: WHERE
456: moq.organization_id = g_organization_id
457: AND moq.inventory_item_id = g_inventory_item_id
458: AND moq.organization_id = mils.organization_id (+)

Line 479: ,mtl_item_locations loc

475: and x.inventory_item_id = lot.inventory_item_id (+)
476: and x.lot_number = lot.lot_number (+)
477: ) x
478: ,mtl_secondary_inventories sub
479: ,mtl_item_locations loc
480: WHERE x.organization_id = loc.organization_id (+)
481: AND x.locator_id = loc.inventory_location_id (+)
482: AND sub.organization_id = x.organization_id
483: AND sub.secondary_inventory_name = x.subinventory_code