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

Line 84: MTL_LOT_NUMBERS mlna ,

80: ,NULL consist_string
81: ,NULL order_by_string
82: from MTL_ITEM_LOCATIONS mil
83: ,
84: MTL_LOT_NUMBERS mlna ,
85: WMS_TRX_DETAILS_TMP_V mptdtv
86: ,(
87: select msn.current_organization_id organization_id
88: ,msn.inventory_item_id

Line 118: ,mtl_lot_numbers lot

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

Line 177: MTL_LOT_NUMBERS mlna ,

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

Line 211: ,mtl_lot_numbers lot

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

Line 286: MTL_LOT_NUMBERS mlna ,

282: ,NULL consist_string
283: ,NULL order_by_string
284: from MTL_ITEM_LOCATIONS mil
285: ,
286: MTL_LOT_NUMBERS mlna ,
287: WMS_TRX_DETAILS_TMP_V mptdtv
288: ,(
289: select msn.current_organization_id organization_id
290: ,msn.inventory_item_id

Line 320: ,mtl_lot_numbers lot

316: ,NULL location_current_units
317: from mtl_serial_numbers msn
318: ,mtl_secondary_inventories sub
319: ,mtl_item_locations loc
320: ,mtl_lot_numbers lot
321: where msn.current_status = 3
322: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
323: decode(g_unit_number, '-9999', 'a', g_unit_number)
324: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 392: MTL_LOT_NUMBERS mlna ,

388: ,NULL consist_string
389: ,NULL order_by_string
390: from MTL_ITEM_LOCATIONS mil
391: ,
392: MTL_LOT_NUMBERS mlna ,
393: WMS_TRX_DETAILS_TMP_V mptdtv
394: ,(
395: SELECT x.organization_id organization_id
396: ,x.inventory_item_id inventory_item_id

Line 481: ,mtl_lot_numbers lot

477: HAVING
478: sum(moq.primary_transaction_quantity) > 0 -- high volume project 8546026
479: ) x
480: ,mtl_secondary_inventories sub
481: ,mtl_lot_numbers lot
482: where
483: -- x.primary_quantity > 0 and -- high volume project 8546026
484: x.organization_id = sub.organization_id
485: and x.subinventory_code = sub.secondary_inventory_name