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

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

178: ,NULL consist_string
179: ,NULL order_by_string
180: from PJM_PROJECT_PARAMETERS ppp
181: ,PJM_PROJECTS_ORG_V ppovs
182: ,MTL_ITEM_LOCATIONS mil
183: ,
184: MTL_LOT_NUMBERS mlna ,
185: WMS_TRX_DETAILS_TMP_V mptdtv
186: ,(

Line 217: ,mtl_item_locations loc

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

Line 296: ,MTL_ITEM_LOCATIONS mil

292: ,NULL consist_string
293: ,NULL order_by_string
294: from PJM_PROJECT_PARAMETERS ppp
295: ,PJM_PROJECTS_ORG_V ppovs
296: ,MTL_ITEM_LOCATIONS mil
297: ,
298: MTL_LOT_NUMBERS mlna ,
299: WMS_TRX_DETAILS_TMP_V mptdtv
300: ,(

Line 331: ,mtl_item_locations loc

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

Line 407: ,MTL_ITEM_LOCATIONS mil

403: ,NULL consist_string
404: ,NULL order_by_string
405: from PJM_PROJECT_PARAMETERS ppp
406: ,PJM_PROJECTS_ORG_V ppovs
407: ,MTL_ITEM_LOCATIONS mil
408: ,
409: MTL_LOT_NUMBERS mlna ,
410: WMS_TRX_DETAILS_TMP_V mptdtv
411: ,(

Line 479: mtl_onhand_quantities_detail moq,mtl_item_locations mils

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

Line 508: ,mtl_item_locations loc

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