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

Line 83: ,MTL_ITEM_LOCATIONS mil

79: ,NULL consist_string
80: ,NULL order_by_string
81: from PJM_PROJECT_PARAMETERS ppp
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 177: ,MTL_ITEM_LOCATIONS mil

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

Line 210: ,mtl_item_locations loc

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

Line 287: ,MTL_ITEM_LOCATIONS mil

283: ,NULL consist_string
284: ,NULL order_by_string
285: from PJM_PROJECT_PARAMETERS ppp
286: ,PJM_PROJECTS_ORG_V ppovs
287: ,MTL_ITEM_LOCATIONS mil
288: ,WMS_TRX_DETAILS_TMP_V mptdtv
289: ,(
290: select msn.current_organization_id organization_id
291: ,msn.inventory_item_id

Line 320: ,mtl_item_locations loc

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

Line 394: ,MTL_ITEM_LOCATIONS mil

390: ,NULL consist_string
391: ,NULL order_by_string
392: from PJM_PROJECT_PARAMETERS ppp
393: ,PJM_PROJECTS_ORG_V ppovs
394: ,MTL_ITEM_LOCATIONS mil
395: ,WMS_TRX_DETAILS_TMP_V mptdtv
396: ,(
397: SELECT x.organization_id organization_id
398: ,x.inventory_item_id inventory_item_id

Line 464: mtl_onhand_quantities_detail moq,mtl_item_locations mils

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

Line 489: ,mtl_item_locations loc

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