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

79: ,base.grade_code
80: ,NULL consist_string
81: ,NULL order_by_string
82: from PJM_PROJECTS_ORG_V ppovs
83: ,MTL_ITEM_LOCATIONS mil
84: ,
85: MTL_LOT_NUMBERS mlna ,
86: WMS_TRX_DETAILS_TMP_V mptdtv
87: ,(

Line 118: ,mtl_item_locations loc

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

Line 178: ,MTL_ITEM_LOCATIONS mil

174: ,base.grade_code
175: ,NULL consist_string
176: ,NULL order_by_string
177: from PJM_PROJECTS_ORG_V ppovs
178: ,MTL_ITEM_LOCATIONS mil
179: ,
180: MTL_LOT_NUMBERS mlna ,
181: WMS_TRX_DETAILS_TMP_V mptdtv
182: ,(

Line 213: ,mtl_item_locations loc

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

Line 289: ,MTL_ITEM_LOCATIONS mil

285: ,base.grade_code
286: ,NULL consist_string
287: ,NULL order_by_string
288: from PJM_PROJECTS_ORG_V ppovs
289: ,MTL_ITEM_LOCATIONS mil
290: ,
291: MTL_LOT_NUMBERS mlna ,
292: WMS_TRX_DETAILS_TMP_V mptdtv
293: ,(

Line 324: ,mtl_item_locations loc

320: ,NULL empty_flag
321: ,NULL location_current_units
322: from mtl_serial_numbers msn
323: ,mtl_secondary_inventories sub
324: ,mtl_item_locations loc
325: ,mtl_lot_numbers lot
326: where msn.current_status = 3
327: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
328: decode(g_unit_number, '-9999', 'a', g_unit_number)

Line 397: ,MTL_ITEM_LOCATIONS mil

393: ,base.grade_code
394: ,NULL consist_string
395: ,NULL order_by_string
396: from PJM_PROJECTS_ORG_V ppovs
397: ,MTL_ITEM_LOCATIONS mil
398: ,
399: MTL_LOT_NUMBERS mlna ,
400: WMS_TRX_DETAILS_TMP_V mptdtv
401: ,(

Line 469: mtl_onhand_quantities_detail moq,mtl_item_locations mils

465: ,moq.lpn_id lpn_id
466: ,decode(mils.project_id, mils.project_id, moq.project_id) project_id
467: ,decode(mils.task_id, mils.task_id, moq.task_id) task_id
468: FROM
469: mtl_onhand_quantities_detail moq,mtl_item_locations mils
470: WHERE
471: moq.organization_id = g_organization_id
472: AND moq.inventory_item_id = g_inventory_item_id
473: AND moq.organization_id = mils.organization_id (+)

Line 498: ,mtl_item_locations loc

494: and x.inventory_item_id = lot.inventory_item_id (+)
495: and x.lot_number = lot.lot_number (+)
496: ) x
497: ,mtl_secondary_inventories sub
498: ,mtl_item_locations loc
499: WHERE x.organization_id = loc.organization_id (+)
500: AND x.locator_id = loc.inventory_location_id (+)
501: AND sub.organization_id = x.organization_id
502: AND sub.secondary_inventory_name = x.subinventory_code