APPS.WMS_TASK_DISPATCH_GEN dependencies on MTL_LOT_NUMBERS

Line 2142: FROM mtl_lot_numbers

2138: IF (l_action <> 3) THEN
2139: -- Lot controlled. Get expiration date
2140: SELECT expiration_date
2141: INTO l_exp_date
2142: FROM mtl_lot_numbers
2143: WHERE organization_id = l_org_id
2144: AND inventory_item_id = l_item_id
2145: AND lot_number = l_lot;
2146: END IF;

Line 13946: FROM mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt

13942: IF (p_lpn_id IS NULL
13943: OR p_lpn_id = 0) THEN
13944: SELECT COUNT(*)
13945: INTO x_lot_num_lov_count
13946: FROM mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt
13947: WHERE mln.organization_id = p_organization_id
13948: AND mln.inventory_item_id = p_item_id
13949: AND mln.lot_number LIKE(p_lot_number || '%')
13950: AND mtlt.lot_number = mln.lot_number

Line 13970: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc

13966: ELSE
13967: -- It however remains same for LPNs
13968: SELECT COUNT(*)
13969: INTO x_lot_num_lov_count
13970: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc
13971: WHERE mln.organization_id = p_organization_id
13972: AND mln.inventory_item_id = p_item_id
13973: AND mln.lot_number LIKE(p_lot_number || '%')
13974: AND moq.lot_number = mln.lot_number

Line 14008: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt

14004: IF (p_lpn_id IS NULL
14005: OR p_lpn_id = 0) THEN
14006: SELECT COUNT(*)
14007: INTO x_lot_num_lov_count
14008: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt
14009: WHERE mln.organization_id = p_organization_id
14010: AND mln.inventory_item_id = p_item_id
14011: AND mln.lot_number LIKE(p_lot_number || '%')
14012: AND moq.lot_number = mln.lot_number

Line 14037: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc

14033: ) = 'Y';
14034: ELSE
14035: SELECT COUNT(*)
14036: INTO x_lot_num_lov_count
14037: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers_all_v mln, mtl_transaction_lots_temp mtlt, wms_lpn_contents wlc
14038: WHERE mln.organization_id = p_organization_id
14039: AND mln.inventory_item_id = p_item_id
14040: AND mln.lot_number LIKE(p_lot_number || '%')
14041: AND moq.lot_number = mln.lot_number