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 84: ,MTL_ITEM_LOCATIONS mil

80: ,NULL consist_string
81: ,NULL order_by_string
82: from PA_TASKS pt
83: ,PJM_PROJECTS_ORG_V ppovs
84: ,MTL_ITEM_LOCATIONS mil
85: ,
86: MTL_LOT_NUMBERS mlna ,
87: WMS_TRX_DETAILS_TMP_V mptdtv
88: ,(

Line 119: ,mtl_item_locations loc

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

Line 181: ,MTL_ITEM_LOCATIONS mil

177: ,NULL consist_string
178: ,NULL order_by_string
179: from PA_TASKS pt
180: ,PJM_PROJECTS_ORG_V ppovs
181: ,MTL_ITEM_LOCATIONS mil
182: ,
183: MTL_LOT_NUMBERS mlna ,
184: WMS_TRX_DETAILS_TMP_V mptdtv
185: ,(

Line 216: ,mtl_item_locations loc

212: ,NULL empty_flag
213: ,NULL location_current_units
214: from mtl_serial_numbers msn
215: ,mtl_secondary_inventories sub
216: ,mtl_item_locations loc
217: ,mtl_lot_numbers lot
218: where msn.current_status = 3
219: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
220: decode(g_unit_number, '-9999', 'a', g_unit_number)

Line 294: ,MTL_ITEM_LOCATIONS mil

290: ,NULL consist_string
291: ,NULL order_by_string
292: from PA_TASKS pt
293: ,PJM_PROJECTS_ORG_V ppovs
294: ,MTL_ITEM_LOCATIONS mil
295: ,
296: MTL_LOT_NUMBERS mlna ,
297: WMS_TRX_DETAILS_TMP_V mptdtv
298: ,(

Line 329: ,mtl_item_locations loc

325: ,NULL empty_flag
326: ,NULL location_current_units
327: from mtl_serial_numbers msn
328: ,mtl_secondary_inventories sub
329: ,mtl_item_locations loc
330: ,mtl_lot_numbers lot
331: where msn.current_status = 3
332: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
333: decode(g_unit_number, '-9999', 'a', g_unit_number)

Line 404: ,MTL_ITEM_LOCATIONS mil

400: ,NULL consist_string
401: ,NULL order_by_string
402: from PA_TASKS pt
403: ,PJM_PROJECTS_ORG_V ppovs
404: ,MTL_ITEM_LOCATIONS mil
405: ,
406: MTL_LOT_NUMBERS mlna ,
407: WMS_TRX_DETAILS_TMP_V mptdtv
408: ,(

Line 476: mtl_onhand_quantities_detail moq,mtl_item_locations mils

472: ,moq.lpn_id lpn_id
473: ,decode(mils.project_id, mils.project_id, moq.project_id) project_id
474: ,decode(mils.task_id, mils.task_id, moq.task_id) task_id
475: FROM
476: mtl_onhand_quantities_detail moq,mtl_item_locations mils
477: WHERE
478: moq.organization_id = g_organization_id
479: AND moq.inventory_item_id = g_inventory_item_id
480: AND moq.organization_id = mils.organization_id (+)

Line 505: ,mtl_item_locations loc

501: and x.inventory_item_id = lot.inventory_item_id (+)
502: and x.lot_number = lot.lot_number (+)
503: ) x
504: ,mtl_secondary_inventories sub
505: ,mtl_item_locations loc
506: WHERE x.organization_id = loc.organization_id (+)
507: AND x.locator_id = loc.inventory_location_id (+)
508: AND sub.organization_id = x.organization_id
509: AND sub.secondary_inventory_name = x.subinventory_code