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

Line 83: ,MTL_ITEM_LOCATIONS mil

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

Line 116: ,mtl_item_locations loc

112: ,NULL empty_flag
113: ,NULL location_current_units
114: from mtl_serial_numbers msn
115: ,mtl_secondary_inventories sub
116: ,mtl_item_locations loc
117: ,mtl_lot_numbers lot
118: where msn.current_status = 3
119: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
120: decode(g_unit_number, '-9999', 'a', g_unit_number)

Line 176: ,MTL_ITEM_LOCATIONS mil

172: ,NULL consist_string
173: ,NULL order_by_string
174: from PA_TASKS pt
175: ,PJM_PROJECTS_ORG_V ppovs
176: ,MTL_ITEM_LOCATIONS mil
177: ,WMS_TRX_DETAILS_TMP_V mptdtv
178: ,(
179: select msn.current_organization_id organization_id
180: ,msn.inventory_item_id

Line 209: ,mtl_item_locations loc

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

Line 285: ,MTL_ITEM_LOCATIONS mil

281: ,NULL consist_string
282: ,NULL order_by_string
283: from PA_TASKS pt
284: ,PJM_PROJECTS_ORG_V ppovs
285: ,MTL_ITEM_LOCATIONS mil
286: ,WMS_TRX_DETAILS_TMP_V mptdtv
287: ,(
288: select msn.current_organization_id organization_id
289: ,msn.inventory_item_id

Line 318: ,mtl_item_locations loc

314: ,NULL empty_flag
315: ,NULL location_current_units
316: from mtl_serial_numbers msn
317: ,mtl_secondary_inventories sub
318: ,mtl_item_locations loc
319: ,mtl_lot_numbers lot
320: where msn.current_status = 3
321: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
322: decode(g_unit_number, '-9999', 'a', g_unit_number)

Line 391: ,MTL_ITEM_LOCATIONS mil

387: ,NULL consist_string
388: ,NULL order_by_string
389: from PA_TASKS pt
390: ,PJM_PROJECTS_ORG_V ppovs
391: ,MTL_ITEM_LOCATIONS mil
392: ,WMS_TRX_DETAILS_TMP_V mptdtv
393: ,(
394: SELECT x.organization_id organization_id
395: ,x.inventory_item_id inventory_item_id

Line 461: mtl_onhand_quantities_detail moq,mtl_item_locations mils

457: ,moq.lpn_id lpn_id
458: ,decode(mils.project_id, mils.project_id, moq.project_id) project_id
459: ,decode(mils.task_id, mils.task_id, moq.task_id) task_id
460: FROM
461: mtl_onhand_quantities_detail moq,mtl_item_locations mils
462: WHERE
463: moq.organization_id = g_organization_id
464: AND moq.inventory_item_id = g_inventory_item_id
465: AND moq.organization_id = mils.organization_id (+)

Line 486: ,mtl_item_locations loc

482: and x.inventory_item_id = lot.inventory_item_id (+)
483: and x.lot_number = lot.lot_number (+)
484: ) x
485: ,mtl_secondary_inventories sub
486: ,mtl_item_locations loc
487: WHERE x.organization_id = loc.organization_id (+)
488: AND x.locator_id = loc.inventory_location_id (+)
489: AND sub.organization_id = x.organization_id
490: AND sub.secondary_inventory_name = x.subinventory_code