APPS.WMS_RULE_17 dependencies on MTL_LOT_NUMBERS

Line 116: ,mtl_lot_numbers lot

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

Line 207: ,mtl_lot_numbers lot

203: ,NULL location_current_units
204: from mtl_serial_numbers msn
205: ,mtl_secondary_inventories sub
206: ,mtl_item_locations loc
207: ,mtl_lot_numbers lot
208: where msn.current_status = 3
209: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
210: decode(g_unit_number, '-9999', 'a', g_unit_number)
211: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 314: ,mtl_lot_numbers lot

310: ,NULL location_current_units
311: from mtl_serial_numbers msn
312: ,mtl_secondary_inventories sub
313: ,mtl_item_locations loc
314: ,mtl_lot_numbers lot
315: where msn.current_status = 3
316: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
317: decode(g_unit_number, '-9999', 'a', g_unit_number)
318: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 470: ,mtl_lot_numbers lot

466: ,decode(mils.project_id, mils.project_id, moq.project_id)
467: ,decode(mils.task_id, mils.task_id, moq.task_id)
468: ) x
469: ,mtl_secondary_inventories sub
470: ,mtl_lot_numbers lot
471: where x.primary_quantity > 0
472: and x.organization_id = sub.organization_id
473: and x.subinventory_code = sub.secondary_inventory_name
474: and x.organization_id = lot.organization_id (+)