APPS.WMS_RULE_14 dependencies on MTL_LOT_NUMBERS

Line 114: ,mtl_lot_numbers lot

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

Line 197: ,mtl_lot_numbers lot

193: ,NULL location_current_units
194: from mtl_serial_numbers msn
195: ,mtl_secondary_inventories sub
196: ,mtl_item_locations loc
197: ,mtl_lot_numbers lot
198: where msn.current_status = 3
199: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
200: decode(g_unit_number, '-9999', 'a', g_unit_number)
201: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 296: ,mtl_lot_numbers lot

292: ,NULL location_current_units
293: from mtl_serial_numbers msn
294: ,mtl_secondary_inventories sub
295: ,mtl_item_locations loc
296: ,mtl_lot_numbers lot
297: where msn.current_status = 3
298: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
299: decode(g_unit_number, '-9999', 'a', g_unit_number)
300: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 444: ,mtl_lot_numbers lot

440: ,decode(mils.project_id, mils.project_id, moq.project_id)
441: ,decode(mils.task_id, mils.task_id, moq.task_id)
442: ) x
443: ,mtl_secondary_inventories sub
444: ,mtl_lot_numbers lot
445: where x.primary_quantity > 0
446: and x.organization_id = sub.organization_id
447: and x.subinventory_code = sub.secondary_inventory_name
448: and x.organization_id = lot.organization_id (+)