APPS.WMS_RULE_18 dependencies on MTL_LOT_NUMBERS

Line 115: ,mtl_lot_numbers lot

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

Line 204: ,mtl_lot_numbers lot

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

Line 309: ,mtl_lot_numbers lot

305: ,NULL location_current_units
306: from mtl_serial_numbers msn
307: ,mtl_secondary_inventories sub
308: ,mtl_item_locations loc
309: ,mtl_lot_numbers lot
310: where msn.current_status = 3
311: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
312: decode(g_unit_number, '-9999', 'a', g_unit_number)
313: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 463: ,mtl_lot_numbers lot

459: ,decode(mils.project_id, mils.project_id, moq.project_id)
460: ,decode(mils.task_id, mils.task_id, moq.task_id)
461: ) x
462: ,mtl_secondary_inventories sub
463: ,mtl_lot_numbers lot
464: where x.primary_quantity > 0
465: and x.organization_id = sub.organization_id
466: and x.subinventory_code = sub.secondary_inventory_name
467: and x.organization_id = lot.organization_id (+)