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_4 dependencies on MTL_LOT_NUMBERS

Line 85: MTL_LOT_NUMBERS mlna ,

81: ,msn.SERIAL_NUMBER order_by_string
82: from MTL_SERIAL_NUMBERS msn
83: ,MTL_SYSTEM_ITEMS msi
84: ,
85: MTL_LOT_NUMBERS mlna ,
86: WMS_TRX_DETAILS_TMP_V mptdtv
87: ,(
88: select msn.current_organization_id organization_id
89: ,msn.inventory_item_id

Line 119: ,mtl_lot_numbers lot

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)
123: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 183: MTL_LOT_NUMBERS mlna ,

179: ,msn.SERIAL_NUMBER order_by_string
180: from MTL_SERIAL_NUMBERS msn
181: ,MTL_SYSTEM_ITEMS msi
182: ,
183: MTL_LOT_NUMBERS mlna ,
184: WMS_TRX_DETAILS_TMP_V mptdtv
185: ,(
186: select msn.current_organization_id organization_id
187: ,msn.inventory_item_id

Line 217: ,mtl_lot_numbers lot

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)
221: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 298: MTL_LOT_NUMBERS mlna ,

294: ,msn.SERIAL_NUMBER order_by_string
295: from MTL_SERIAL_NUMBERS msn
296: ,MTL_SYSTEM_ITEMS msi
297: ,
298: MTL_LOT_NUMBERS mlna ,
299: WMS_TRX_DETAILS_TMP_V mptdtv
300: ,(
301: select msn.current_organization_id organization_id
302: ,msn.inventory_item_id

Line 332: ,mtl_lot_numbers lot

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)
336: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 410: MTL_LOT_NUMBERS mlna ,

406: ,msn.SERIAL_NUMBER order_by_string
407: from MTL_SERIAL_NUMBERS msn
408: ,MTL_SYSTEM_ITEMS msi
409: ,
410: MTL_LOT_NUMBERS mlna ,
411: WMS_TRX_DETAILS_TMP_V mptdtv
412: ,(
413: SELECT x.organization_id organization_id
414: ,x.inventory_item_id inventory_item_id

Line 499: ,mtl_lot_numbers lot

495: HAVING
496: sum(moq.primary_transaction_quantity) > 0 -- high volume project 8546026
497: ) x
498: ,mtl_secondary_inventories sub
499: ,mtl_lot_numbers lot
500: where
501: -- x.primary_quantity > 0 and -- high volume project 8546026
502: x.organization_id = sub.organization_id
503: and x.subinventory_code = sub.secondary_inventory_name