APPS.WMS_RULE_15 dependencies on MTL_LOT_NUMBERS

Line 117: ,mtl_lot_numbers lot

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

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 321: ,mtl_lot_numbers lot

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

Line 480: ,mtl_lot_numbers lot

476: ,decode(mils.project_id, mils.project_id, moq.project_id)
477: ,decode(mils.task_id, mils.task_id, moq.task_id)
478: ) x
479: ,mtl_secondary_inventories sub
480: ,mtl_lot_numbers lot
481: where x.primary_quantity > 0
482: and x.organization_id = sub.organization_id
483: and x.subinventory_code = sub.secondary_inventory_name
484: and x.organization_id = lot.organization_id (+)